Lightweight Advanced and Smart QueryBuilder
dev-main
2026-03-05 00:10 UTC
This package is auto-updated.
Last update: 2026-03-05 00:10:40 UTC
README
LNO Not ORM
Simple Library to turn warp SQL in a smart way. Carries the heavy left from you when you write SQL, without the unlimited complexity in the big Frameworks, just write a human-readable code and boom, you have SQL Query without Syntax errors and talk to your Database with the most secure way and Best practicies. also Lightweight you know?
Why I made LNO?
I just wanted to keep using pure PHP until I become good enough in OOP, MVC and most of backend concepts that Framework hide from you. I started with a very basic one but I found it useless so I remade it.
Features
- MySQL support by Default (I will add PostgreSQL later...).
- Auto Order for parts.
- RAW SQL with {} for escaping.
- Multi-Query Support.
- Advanced Nested where conditions.
- UNION Support.
- Issues handler, to protect your db.
- Method Chaining.
- Automatic Backticks.
- Rollback and Transactions for Multiple or single Query.
- Infinity of Joins.
- Insert-Select Support.
- Multiple Values support for Insert.
- Safe DELETE and UPDATE.
- Dependency Injection for DB Driver.
Requirements
- PHP 8.2 or later.
Quick Start
Installation
Just use composer, install the package mohamedsaleh077/lno .