Libraries tagged by sql statement

Use SQL statements to query elasticsearch

Go to Download

A MySQL Query Builder for effortlessly composing SQL statements with support for executing them against databases.

Go to Download

Simple, lightweight SQL statement abstraction.

Go to Download

A driver-agnostic database library for PHP providing convenient methods for escaping, preparing and executing statements.

Go to Download

Reduce multi-relation Doctrine queries to a single SQL statement using JSON aggregation. Solves Doctrine's N+1 problem.

Go to Download

A library for converting a jQuery query builder JSON rules string to an SQL statement.

Go to Download

SQLCommenter implementation for Laravel. SQLCommenter is a set of tools that augments SQL Statements with comments containing information about the code that caused its execution. These information can be action, controller, framework, db_driver, route and opentelemetry traceparent.

Go to Download

Framework agnostic datagrid - Instantly convert any SQL SELECT statement into a fully featured datagrid

Go to Download

PHP class to extract data from (csv) file and transform it to (sql) file as insert statement.

Go to Download

Faker Provider for generating syntactically valid SQL statements

Go to Download

Write a DSL to generate valid SQL statements for SELECT, INSERT, UPDATE and DELETE

Go to Download

Generate SQL statements

Go to Download

Based on the lexical analysis of "update," "select," "insert," and "delete" SQL statements, an automatic caching strategy is implemented. The strategy involves caching the data when executing a select operation and associating the table name contained in the SQL statement with the corresponding cached records. When executing update, insert, or delete operations, the table name from the SQL statement is extracted, and any cached records containing this table name from previous select operations are deleted. This strategy enables seamless caching without delay and eliminates the need to worry about data synchronization issues. It is particularly effective for tables with infrequent data modifications. For tables with frequent modifications, they can be ignored by configuring the strategy accordingly.

Go to Download

Allows user to construct reports using sql select statements to run through model admin

Go to Download

Library for lexing and parsing a SQL INSERT statement

Go to Download