Libraries tagged by sql statement

This package contains classes useful to generate SQL statements such as SELECT queries, etc...

Go to Download

The PersistentPDO object is used to connect with a database and to generate sql statements on the go.

Go to Download

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

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

A very lightweight PHP class that reformats unreadable and computer-generated SQL query statements to human-friendly, readable text.

Go to Download

A Laravel package to convert raw SQL CREATE TABLE statements into Laravel migrations automatically.

Go to Download

Helper for converting json-schemas to sql create table statement

Go to Download

A helper to extract SQL column aliases from SELECT statements

Go to Download

Check SQL performance

Go to Download

Library to connect on SQL Databases with PDO Connection.

Go to Download