skills.homes logoskills.homescapability registry
home/categories/sql-databases/openaec-foundation-frappe-claude-skill-package-skills-source-syntax-frappe-syntax-query-builder-skill-md
cd ..
sql-databasesdatabases

frappe-syntax-query-builder

Use when building database queries with frappe.qb in Frappe v14-v16. Covers the PyPika-based query builder: SELECT, INSERT, UPDATE, DELETE, joins, aggregation, subqueries, cross-DB compatibility (MariaDB/PostgreSQL), and migration from raw SQL. Prevents SQL injection and DB-specific bugs. Keywords: frappe.qb, query builder, DocType, Field, pypika, join,, frappe.qb example, how to write query, join tables, SQL replacement, parameterized query. aggregate, ImportMapper, cross-database, parameterized query.

檢視原始碼sql-databases
OpenAEC-Foundation
maintainer
OpenAEC-Foundation
更新於 3/30/2026
星標
68
分支
17
quick start

Installation and usage

Use when building database queries with frappe.qb in Frappe v14-v16. Covers the PyPika-based query builder: SELECT, INSERT, UPDATE, DELETE, joins, aggregation, subqueries, cross-DB compatibility (MariaDB/PostgreSQL), and migration from raw SQL. Prevents SQL injection and DB-specific bugs. Keywords: frappe.qb, query builder, DocType, Field, pypika, join,, frappe.qb example, how to write query, join tables, SQL replacement, parameterized query. aggregate, ImportMapper, cross-database, parameterized query.

安裝
$ install --globalskills.sh
使用

安裝後，您可以透過在終端機執行以下指令來使用此技能：

skills use frappe-syntax-query-builder