Tagged articles
query builder
19 articles · Page 1 of 1
This article introduces Yii Database 2.0—a modernized PHP database abstraction layer with new drivers, enhanced type safety, and powerful features—then walks through Composer installation, basic connection setup, and practical query, insert, and transaction examples.
ORMPHPYii
0 likes · 4 min read

Laravel 11 introduces a suite of enhancements—including a refined HTTP client with retry support, advanced query‑builder aggregation methods, streamlined testing assertions, expanded Blade component directives, and native type‑safe routing—to boost performance, simplify development workflows, and improve code maintainability for PHP developers.
BladeHTTP ClientPHP
0 likes · 4 min read

This article explains why the author created the EasyQuery ORM for Java, demonstrates a wide range of query patterns—including single‑record, pagination, joins, subqueries, streaming, custom VO mapping, dynamic conditions, grouping, native SQL, function columns, and high‑performance encryption—while providing complete code snippets and links to documentation and source repositories.
BackendJavaORM
0 likes · 13 min read

The latest ThinkORM release, now independent from ThinkPHP and requiring PHP 8.0+, introduces extensive JSON handling improvements, new query methods, mutator enhancements, and numerous bug fixes that boost performance and developer experience for PHP database applications.
JSONMutatorsORM
0 likes · 3 min read

This article introduces Easy‑Query, a Java ORM that provides a strongly‑typed, chainable query syntax covering basic CRUD, pagination, joins, sub‑queries, native SQL fragments, group‑by, custom VO mapping and high‑performance encryption, illustrated with extensive code examples and usage notes.
BackendEasy-QueryJava
0 likes · 13 min read

This guide walks through installing pypika and demonstrates how to construct SELECT, WHERE, GROUP BY, JOIN, subqueries, set operations, INSERT, UPDATE, and database‑specific adaptations using Python code, showcasing concrete examples and the full query‑building workflow.
BackendPythonSQL
0 likes · 24 min read

This tutorial explains how to create a lightweight Python ORM without using metaclasses, covering the design of Field, Compare, Model, and Query classes, demonstrating insert and select operations, and extending query capabilities with LIMIT, OFFSET, GROUP BY, and HAVING.
MetaclassORMquery builder
0 likes · 9 min read

Grafana 9.0 focuses on improving user experience for observability and data visualization, introducing visual Prometheus and Loki query builders, an Explore‑to‑dashboard workflow, a revamped heatmap panel, command palette, panel search, trace panels, navigation upgrades, and enhanced alerting, all aimed at making data discovery and investigation more intuitive and efficient.
DashboardGrafanaLoki
0 likes · 9 min read

This article introduces the Laravel‑query‑builder package, explaining how to replace complex IF‑ELSE query logic with a configuration‑driven approach, and provides installation steps, usage examples, and code snippets for building flexible SQL queries in Laravel applications.
BackendConfigurationPHP
0 likes · 3 min read

This article provides a comprehensive guide to Laravel's query builder, covering basic CRUD commands, selective column retrieval, complex where clauses, joins, aggregations, raw expressions, inserts, updates, deletions, unions, locking mechanisms, and query caching with clear code examples for each feature.
CRUDLaravelPHP
0 likes · 8 min read

A concise Laravel DB cheat sheet that covers basic usage, query builder methods, joins, aggregates, inserts, updates, deletes, unions, and pessimistic locking with clear code examples for each operation.
DBLaravelPHP
0 likes · 8 min read

This article explains the differences between Laravel's ORM and DB query builder, outlines their advantages and appropriate use cases, and provides step‑by‑step code examples for defining models, retrieving, creating, and deleting records, as well as handling transactions.
LaravelORMPHP
0 likes · 5 min read

This guide explains how Laravel’s query builder offers a secure, fluent interface for constructing and executing database queries, covering result retrieval, filtering, aggregation, joins, unions, inserts, updates, deletes, and advanced features like raw expressions, JSON handling, and pessimistic locking.
CRUDEloquentLaravel
0 likes · 20 min read

This guide explains how to configure Laravel's supported databases, set up SQLite, implement read/write connection splitting, use multiple connections, execute raw SQL queries, listen to query events, and manage transactions—including deadlock handling and manual control—complete with code examples.
ConfigurationLaravelRead/Write
0 likes · 8 min read

This guide explains how Laravel's paginator integrates with the query builder and Eloquent ORM, shows basic and simple pagination methods, demonstrates manual paginator creation, customizing URIs, appending parameters, converting results to JSON, and customizing pagination views, all with code examples compatible with Bootstrap.
EloquentLaravelPHP
0 likes · 10 min read

The article explores the challenges of using GORM for layered query complexity in Go, compares it with sqlx, and proposes an idiomatic, extensible query‑builder design using functional options, complete with example implementations for SELECT, WHERE, and helper functions.
query buildersqlx
0 likes · 11 min read

This article explores the challenges of building layered, flexible database queries in Go, compares GORM, sqlx, and squirrel, and proposes a custom, option‑based query‑builder pattern that stays idiomatic and extensible for complex search scenarios.
BackendGoORM
0 likes · 13 min read

This article explains how Laravel’s Illuminate Database Query Builder class encapsulates connection, grammar, and result processing components, provides a unified query interface, and is instantiated via the table() method while adhering to interface‑driven design principles for consistent database operations.
LaravelPHPdatabase
0 likes · 2 min read

This article explains Laravel's Query Builder and Eloquent ORM, showing how to convert raw SQL into fluent builder methods, create database tables and models, and demonstrate practical querying techniques with nested conditions, aggregation, and result handling.
EloquentLaravelORM
0 likes · 9 min read
