Query builder
A query builder is a programmatic interface for constructing database queries from composable operations rather than manually assembled query text.
Java Persistence with Spring Data and Hibernate epub
A query builder is a mechanism that constructs database queries from structured declarations or repository method definitions.
- How it is used
- Derives retrieval queries from repository method names in Spring Data JPA, JDBC, and MongoDB.
- How deep it goes
- Explains name parsing, keywords, return types, and load-time errors, while identifying JDBC's no-join limit.
- Examples
- Tests user searches by username and registration date alongside compound filters and username ordering.
- What you can do after
- Apply it via Spring Data repository methods to declare property-based searches and recognize when JDBC's derived queries cannot use joins.
Read how Java Persistence with Spring Data and Hibernate epub explains query builder →
DuckDB in Action
A query builder is a programmatic interface that constructs database queries from composable operations rather than manually assembled query text.
- How it is used
- Composes reusable population queries through DuckDB’s relational API.
- How deep it goes
- Explains chaining, deferred execution, reuse, aggregation, ordering, and set operations without descending into query-planner internals.
- Examples
- Uses population filtering, regional averages, counts, exclusions, regular-expression matching, and Eastern European intersections.
- What you can do after
- Apply it via DuckDB’s Python relational API to build, reuse, inspect, and extend lazy database queries.
Related concepts
- Spring Data JPAused by · Spring Data JPA is a Spring module that provides repository abstractions and query support for accessing relational data through JPA implementations.
- query methodused by · A query method is a method that defines, constructs, refines, or evaluates a database query.
- Spring Data MongoDBuses · Spring Data MongoDB is a Spring Data module that provides repository and data-access abstractions for MongoDB document databases.
- Spring Data JDBCused by · Spring Data JDBC is a Spring Data module that provides repository-based access to relational databases through JDBC without requiring a full object-relational mapping framework.
- Spring Dataused by · Spring Data is a family of Spring projects that provides repository-based abstractions for accessing and persisting data across relational and nonrelational stores.
- contractincludes · An API contract is a specification of the operations, data, and behavioral expectations that govern interactions between software components.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.