frappe-core-database

Safe Frappe database queries require parameterized SQL and standardized ORM patterns to prevent injection. This skill enforces parameterization for raw SQL and proper use of frappe.db methods to ensure high-integrity data access across v14–v16.

Use the Frappe ORM for standard CRUD operations to maintain permission handling, and use parameterized raw SQL only for performance-critical or complex queries. This skill provides clear guidance on choosing ORM, raw SQL, or the Query Builder.

Proper transaction handling in ERPNext requires standardized control mechanisms for commits and rollbacks. This skill details transaction management practices to ensure robust data consistency and prevent partial updates during bulk operations.

Optimizing Frappe database performance involves strategic caching and selecting efficient read patterns like get_value or get_list. This skill provides performance-focused strategies and caching guidance to scale ERPNext data access safely.

Yes, these standardized database operations are explicitly designed for compatibility across ERPNext v14 through v16. The skill enforces safe query and transaction practices that apply universally to code using frappe.db within these versions.