Download the PHP package craftix/lite-eloquent without Composer

Lite Eloquent

Lite Eloquent is a lightweight, high-performance PHP database query builder and ORM-inspired library.
It provides an easy-to-use, fluent API for building SQL queries with support for joins, where clauses, pagination, and bindings—without the heavy dependencies.

✨ Features

• 🚀 High-performance PHP database query builder
• 📦 Lightweight and dependency-free (only requires PDO)
• 🔗 Fluent, chainable API similar to Eloquent
• 🔒 Secure with proper parameter bindings (SQL injection protection)
• 🗄️ Multi-dialect support (MySQL, Pgsql)
• 📄 Pagination support (simple and length-aware)
• 🔄 Transaction support
• 📊 Collection class with array-like operations
• 🎯 Type-safe with PHP 8.2+ features

Supported Operations

• ✅ SELECT queries with columns, joins, where clauses, ordering, limit
• ✅ INSERT queries (single and bulk)
• ✅ UPDATE queries with where clauses
• ✅ DELETE queries with where clauses
• ✅ UPSERT operations (MySQL: ON DUPLICATE KEY UPDATE, Pgsql: ON CONFLICT)
• ✅ INSERT OR IGNORE operations
• ✅ Complex WHERE conditions (nested groups, IN, BETWEEN, NULL checks, LIKE, etc.)
• ✅ JOIN clauses (INNER, LEFT, RIGHT, FULL)
• ✅ Raw SQL expressions
• ✅ Pagination (with total count or simple)
• ✅ Database transactions

📦 Installation

Install via Composer:

Requirements:

• PHP >= 8.2
• PDO extension

🚀 Quick Start

Basic Setup

Using Singleton Pattern

📖 Usage Examples

SELECT Queries

Basic Select

WHERE Clauses

JOIN Clauses

Ordering and Limits

Pagination

INSERT Queries

UPSERT Queries

UPDATE Queries

DELETE Queries

Raw Expressions

Transactions

Working with Collections

All query results return a Collection instance with helpful methods:

Custom Object Conversion

Getting SQL Query

Database Dialects

The library automatically detects the database dialect, but you can also set it manually:

🎯 API Reference

QueryBuilder Methods

Query Execution

• get() - Execute SELECT and return Collection
• first(...$columns) - Get first record (returns single value if one column, array if multiple)
• pluck($column) - Get single column as array
• toSql() - Get SQL string without executing
• paginate($page, $perPage, $pageName = 'page') - Length-aware pagination
• simplePaginate($page, $perPage, $pageName = 'page') - Simple pagination

Query Building

• table($table) - Set table name
• select(...$columns) - Select columns
• distinct() - Add DISTINCT
• where($column, $operator, $value, $and = true) - Add WHERE condition
• orWhere($column, $operator, $value) - Add OR WHERE condition
• whereIn($column, $values, $and = true) - WHERE IN
• whereNotIn($column, $values, $and = true) - WHERE NOT IN
• whereBetween($column, $value1, $value2, $and = true) - WHERE BETWEEN
• whereNotBetween($column, $value1, $value2, $and = true) - WHERE NOT BETWEEN
• whereNull($column, $and = true) - WHERE IS NULL
• whereNotNull($column, $and = true) - WHERE IS NOT NULL
• whereLike($column, $value, $and = true) - WHERE LIKE
• whereNotLike($column, $value, $and = true) - WHERE NOT LIKE
• join($table, $column1, $operator, $column2, $type = 'INNER') - Add JOIN
• leftJoin($table, $column1, $operator, $column2) - LEFT JOIN
• rightJoin($table, $column1, $operator, $column2) - RIGHT JOIN
• fullJoin($table, $column1, $operator, $column2) - FULL JOIN
• orderBy($column, $type = 'ASC') - ORDER BY
• orderByDesc($column) - ORDER BY DESC
• inRandomOrder($seed = '') - Random order
• limit($limit) - LIMIT
• offset($offset) - OFFSET

Write Operations

• insert($columnsToValues, &$resultedSql = null) - INSERT
• insertGetId($columnsToValues, $idColumn = 'id', &$resultedSql = null) - INSERT and get ID
• insertOrIgnore($columnsToValues, $uniqueColumns = null, &$resultedSql = null) - INSERT OR IGNORE
• upsert($columnsToValues, $uniqueBy, $updateOnDuplicate = null, &$resultedSql = null) - UPSERT
• update($columnsToValues, &$resultedSql = null) - UPDATE
• delete(&$resultedSql = null) - DELETE

Utilities

• raw($value) - Create raw SQL expression
• getValues() - Get bound parameter values
• objectConverter($callback) - Set result object converter
• setDialect($dialect) - Set SQL dialect

DB Class Methods

• table($table) - Create QueryBuilder instance
• setDialect($dialect) - Set dialect
• getPdo() - Get PDO instance
• beginTransaction() - Start transaction
• commit() - Commit transaction
• rollBack() - Rollback transaction
• inTransaction() - Check if in transaction
• transaction($callback) - Execute in transaction
• lastInsertId() - Get last insert ID
• exec($query, $params = null) - Execute raw SQL
• raw($value) - Create raw expression

Collection Methods

See the Collection documentation section above for available methods.

🔒 Security

This library uses prepared statements with parameter binding by default, protecting against SQL injection attacks. Always use the query builder methods instead of raw SQL when possible.

🐛 Error Handling

The library throws QueryBuilderException for query-related errors:

📝 License

This project is licensed under the MIT License.

🤝 Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

📧 Support

For issues, questions, or contributions, please visit the GitHub repository.

📜 Changelog

[1.1.0] - 2025-12-02

• Improved unit tests
• Added documentation for class methods and properties

[1.0.0] - 2025-11-15

• Initial release with core query builder and collection methods