PHPackages chamamme/noquery - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Database & ORM](/categories/database) 4. / 5. chamamme/noquery ActiveLibrary[Database & ORM](/categories/database) chamamme/noquery ================ A database query builder aimed at code beautification by minimizing the use of raw SQL in codes. NoQuery currently supports MySQL, Firebird & Interbase, PostgreSQL, SQLite3, Oracle, Microsoft SQL Server, Foxpro ODBC, Access ODBC, Informix, DB2, Sybase, Sybase SQL Anywhere, generic ODBC and Microsoft's ADO due to its leverage on ADODB v1.1.0(7y ago)440MITPHPPHP ^7.0 Since Oct 13Pushed 6y ago1 watchersCompare [ Source](https://github.com/mastys100/noquery)[ Packagist](https://packagist.org/packages/chamamme/noquery)[ RSS](/packages/chamamme-noquery/feed)WikiDiscussions master Synced 3d ago READMEChangelog (2)Dependencies (1)Versions (9)Used By (0) NoQuery ======= [](#noquery) NoQuery is a php query builder running on ADODB library. It is aimed at making database interactions easier with less codes. NoQuery currently supports MySQL, Firebird-Interbase, PostgreSQL, SQLite3, Oracle, Microsoft SQL Server, Foxpro ODBC, Access ODBC, Informix, DB2, Sybase, Sybase SQL Anywhere, generic ODBC and Microsoft's ADO due its leverage on ADODB. Installation ------------ [](#installation) ``` > composer require chamamme/noquery ``` Configuration ------------- [](#configuration) ``` NoQuery requires a configuration array. A typical configuration looks like ``` ``` $config = [ 'driver' => 'mysqli', #eg. access,ado,ibase,fbsql,db2,informix,ldap,mssqlnative,netezza,odbc,odbtp,oci8,pdo,postgres9,proxy,ads,sybase_ase,sqlite3,sybase 'server' => "localhost", 'username' => "root", 'password' => "", 'port' => "3306", 'database' => "test_db", 'debug' => false ]; ``` Usage ----- [](#usage) It all starts with an instance of Tablet class which requires a configuration array variable. ``` $db = new NoQuery\Builder( $config ) ``` Now we are ready to interact with our database. Methods ------- [](#methods) NameParams (Type)DescriptionExample` table `` table `(string)Tells orcons-db the database table to interact with.table('users')`select`columns (array)Performs a select query.` select(['name','age']) `` update `args (array)Performs an ` UPDATE ` statement .` update(['name'=>'Andrew','age'=>10]) `` where `conditions (array)Adds an ` where ` clause to sql statement` where(["name = 'Chamamme'])`` orWhere `conditions (array)Adds an ` OR ` clause to sql statement` orWhere([age = 25])`` whereIn `column (string) , conditions (array)Adds an ` WHERE IN ` clause to sql statement` whereIn('age',[ 25 , 6 , 8 ])`` whereNotIn `column (string) , conditions (array)Adds an ` WHERE NOT IN ` clause to sql statement` whereNotIn('age',[ 25 , 6 , 8 ]) `` whereBetween `column (string) , conditions (array)Adds an ` BETWEEN ` clause to sql statement` whereBetween('age',[ 18 ,19 ]) `` orWhereIn `conditions (array)Adds an ` OR IN ` clause to sql statement` orWhereIn(['name'=>'Andrew','age'=>25]) `` get `limit (int), offset (int)Executes the sql statement` get()` or ` get(0,10) `` run `Executes the sql statement` run() `` toSql `returns the final sql statment` toSql() `### Sample [](#sample) ``` require("vendor/autoload.php"); #change to the actual path of your composer autoload.php file use NoQuery\Builder; $config = [ 'driver' => "mysqli", 'server' => "localhost", 'username' => "root", 'password' => "", 'port' => "3306", 'database' => "test_db", 'debug' => false ]; $db = new Builder( $config ) ; #Instantiate the Builder class #select query $db->table('users') ->select(['name','gender','age']) ->get(); #update statement $db->table('users') ->update(['name'=>'Chamamme']) ->where(["id = 5","gender ='male'"]) ->go(); ``` ### Health Score 29 — LowBetter than 59% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity12 Limited adoption so far Community7 Small or concentrated contributor base Maturity63 Established project with proven stability Bus Factor1 Top contributor holds 100% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~44 days Recently: every ~76 days Total 8 Last Release 2826d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/83cbe6a60066fa5c63a1505829de34a7b2297f790f71088d685eeab1de9f3a67?d=identicon)[chamamme](/maintainers/chamamme) --- Top Contributors [![chamamme](https://avatars.githubusercontent.com/u/6322570?v=4)](https://github.com/chamamme "chamamme (43 commits)") --- Tags phpabstractiondatabaselibrarymysqlpostgresqloracledb2layerquery buildersqlite3sybaseinformixmicrosoft sql serverfirebirdinterbaseadodborconsnoqueryFoxpro ODBCAccess ODBCSybase SQL Anywheregeneric ODBCMicrosoft ADO ### Embed Badge ![Health badge](/badges/chamamme-noquery/health.svg) ``` [![Health](https://phpackages.com/badges/chamamme-noquery/health.svg)](https://phpackages.com/packages/chamamme-noquery) ``` ### Alternatives [doctrine/dbal Powerful PHP database abstraction layer (DBAL) with many features for database schema introspection and management. 9.7k578.4M5.6k](/packages/doctrine-dbal)[adodb/adodb-php ADOdb is a PHP database abstraction layer library 4553.9M28](/packages/adodb-adodb-php)[ezsql/ezsql Advance database access library. Make interacting with a database ridiculously easy. An universal interchangeable CRUD system. 86946.7k](/packages/ezsql-ezsql)[jv2222/ezsql Advance database access library. Make interacting with a database ridiculously easy. An universal interchangeable CRUD system. 87311.3k2](/packages/jv2222-ezsql)[tommyknocker/pdo-database-class Framework-agnostic PHP database library with unified API for MySQL, MariaDB, PostgreSQL, SQLite, MSSQL, and Oracle. Query Builder, caching, sharding, window functions, CTEs, JSON, migrations, ActiveRecord, CLI tools, AI-powered analysis. Zero external dependencies. 845.7k](/packages/tommyknocker-pdo-database-class)[moharrum/laravel-adminer Adminer database management tool for your Laravel application. 451.0k](/packages/moharrum-laravel-adminer) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)