Libraries tagged by sql statement

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

A lightweight, fast, and secure PHP library for interacting with databases, creating migrations, and running queries. swew/db uses prepared statements to protect against SQL injection attacks and supports multiple database systems.

Go to Download

SQL query builder with fluent interface, supporting multiple database drivers and prepared statements. Designed for ease of use and flexibility in building complex SQL queries.

Go to Download

Catalog the SQL statements a PHP application issues, by static analysis

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

A Laravel package for generating SQL insert statements from Eloquent model records.

Go to Download

Bidirectional converter between CSV/XLSX and SQL. Import spreadsheets into SQL INSERT statements or directly into MySQL, and export SQL query results to CSV/XLSX files.

Go to Download

SQLite statement models, SQL reconstruction, and schema binding for SQL Semantics

Go to Download

PostgreSQL statement models, SQL reconstruction, and schema binding for SQL Semantics

Go to Download

MySQL statement models, SQL reconstruction, and schema binding for SQL Semantics

Go to Download