Query Builder

Definitions

1. A programmatic API that lets developers construct database queries using method chaining or composable objects instead of writing raw SQL strings. Query builders handle escaping, parameterization, and dialect differences while giving more control than a full ORM — libraries like Knex.js, SQLAlchemy Core, and Eloquent's query builder are common examples.

   In plain English: A tool that lets programmers build database queries by calling functions in their language instead of writing SQL by hand.

   Example: "I used the query builder instead of raw SQL so we get automatic parameter binding and can swap from Postgres to MySQL without rewriting queries."

Related Terms

• Ecto
• Query
• Table
• N+1 Query Problem
• Database Trigger
• KV Store
• Left Join
• MySQL
• PostgreSQL
• Primary Key
• Rails Migration
• Raw SQL
• RDBMS
• SQLAlchemy
• SQLite
• TypeORM