frappe-syntax-query-builder
OfficialBuild robust Frappe.qb queries with confidence.
AuthorOpenAEC-Foundation
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Developers often struggle to write portable, safe database queries across MariaDB and PostgreSQL when using Frappe's query builder, risking syntax drift and injection-prone code.
Core Features & Use Cases
- Cross-db query construction with frappe.qb supporting SELECT, INSERT, UPDATE, DELETE, JOINs, aggregation, and subqueries.
- Safe, parameterized patterns and migrations from raw SQL to the query builder for production-grade code.
- Real-world scenarios including data extraction, reporting, and data integrity checks across multiple DocTypes.
Quick Start
Use the frappe-syntax-query-builder to generate a simple PyPika-based query example for a Sales Order DocType.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: frappe-syntax-query-builder Download link: https://github.com/OpenAEC-Foundation/Frappe_Claude_Skill_Package/archive/main.zip#frappe-syntax-query-builder Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.