fix: Qb query, use `isin` instead of in and access fields without dot notation due to reserved pypika keywords
diff --git a/erpnext/patches/v13_0/populate_e_commerce_settings.py b/erpnext/patches/v13_0/populate_e_commerce_settings.py
index 586009e..8f9ee51 100644
--- a/erpnext/patches/v13_0/populate_e_commerce_settings.py
+++ b/erpnext/patches/v13_0/populate_e_commerce_settings.py
@@ -28,10 +28,10 @@
query = (
frappe.qb.from_(singles)
.select(
- singles.field, singles.value
+ singles["field"], singles.value
).where(
(singles.doctype == doctype)
- & (singles.field in fields)
+ & (singles["field"].isin(fields))
)
)
data = query.run(as_dict=True)