skills.rest
anonymousminati
anonymousminatiCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

frappe-syntax-query-builder

Builds Frappe database queries with frappe.qb across MariaDB and PostgreSQL.

Updated May 31, 2026
Search Tags:#aggregation#sql migration#joins#query builder#cross-db#frappe.qb#pypika
One-click install
npx skills add https://github.com/anonymousminati/Res-POS --skill frappe-syntax-query-builder-anonymousminati
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: frappe-syntax-query-builder
Source: https://github.com/anonymousminati/Res-POS/tree/main/.claude/skills/syntax/frappe-syntax-query-builder
Command: npx skills add https://github.com/anonymousminati/Res-POS --skill frappe-syntax-query-builder-anonymousminati

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps developers replace fragile raw SQL with safe, portable Frappe query builder patterns for database access.

Core Features & Use Cases

  • SELECT, INSERT, UPDATE, and DELETE queries with frappe.qb and DocType-based table references.
  • Joins, filters, aggregation, and subqueries for reporting, lookups, and relational data retrieval.
  • Cross-database compatibility and migration guidance for MariaDB and PostgreSQL projects.
  • Use case: When building an order report with totals by customer and item counts, this Skill shows how to compose the query without raw SQL and avoid injection bugs.

Quick Start

Ask for a frappe.qb query builder example for a Sales Order report with joins, filters, and aggregation.

Frequently Asked Questions about frappe-syntax-query-builder

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I write safe Frappe queries without raw SQL injection risks?▼

Frappe queries use the frappe.qb query builder with DocType-based table references and parameterized execution to prevent injection bugs. This replaces raw SQL with a safe abstraction layer that works across MariaDB and PostgreSQL.

What's the best way to build a Frappe report with joins and aggregation?▼

Building a Frappe report with joins and aggregation uses frappe.qb to compose SELECT queries with relational joins and grouped totals. You link DocType table references and apply aggregation functions to generate reports like order totals by customer without raw SQL.

Does frappe.qb support cross-database compatibility between MariaDB and PostgreSQL?▼

Yes, frappe.qb supports cross-database compatibility between MariaDB and PostgreSQL. It uses an ImportMapper-driven approach to ensure parameterized query builder patterns execute correctly on both database backends during SQL migration.

Can I use frappe.qb for INSERT, UPDATE, and DELETE operations?▼

Yes, frappe.qb supports INSERT, UPDATE, and DELETE operations alongside SELECT queries. You perform safe database modifications using DocType-based table references without writing vulnerable raw SQL strings.

When should I migrate raw SQL to the Frappe query builder?▼

You should migrate raw SQL to the Frappe query builder when you need portable database access across MariaDB and PostgreSQL. This eliminates injection bugs and ensures cross-database compatibility during Frappe v14-v16 application development.

Related Skills

Explore More Software Engineering Skills→
Shamrock2245Shamrock2245
1

connecting-streamlit-to-snowflake

Establishes Snowflake database connections from Streamlit apps using st.connection and session writes.

Community
Intermediate
kubiyabotkubiyabot
16

mysql

Execute SQL queries against MySQL databases using a Docker-based client.

Official
Advanced
puzzo-devpuzzo-dev

frappe-desk

Customize Frappe Desk workspaces, reports, portal pages, and Vue.js integrations.

Community
Advanced
Impertio-StudioImpertio-Studio
163

frappe-syntax-query-builder

Build secure Frappe database queries using the frappe.qb API.

Official
Intermediate