frappe-database-orm
Installation
SKILL.md
Frappe Database / ORM
Prefer the ORM; drop to SQL only when needed, and only parameterized.
Reads
frappe.get_doc("Sales Order", "SO-0001") # full document (all children)
frappe.db.get_value("Sales Order", "SO-0001", "status") # one field, fast
frappe.db.get_value("Sales Order", {"customer": "ACME"}, ["name", "status"], as_dict=True)
frappe.get_all("Sales Order",
filters={"status": "Draft", "grand_total": [">", 1000]},
fields=["name", "customer", "grand_total"],
order_by="creation desc", limit=50)
frappe.get_list(...) # same, but enforces the current user's permissions
get_all ignores user permissions (use server-side); get_list enforces them (use for user-facing).