Pyodbc in erpnext

Frappe Framework
,
1

Can we import other packages like pyodbc or mysql.connector in erpnext and use database connection code like other normal python files?

2

Found the solution

3

To manipulate ERPNext documents, use the wrapper functions or frappe.db.sql("SELECT * FROM *") for complicated queries.

If you need to talk to a different database (not ERPNext), you can still use the tools you mentioned.