Ecosyste.ms: Packages

An open API service providing package, version and dependency metadata of many open source software ecosystems and registries.

packagist.org "query builder" keyword

Top 0.8% on packagist.org
foolz/sphinxql-query-builder 3.0.2
A PHP query builder for SphinxQL. Uses MySQLi to connect to the Sphinx server.
38 versions - Latest release: about 2 years ago - 37 dependent packages - 65 dependent repositories - 1.7 million downloads total - 326 stars on GitHub - 2 maintainers
Top 0.7% on packagist.org
usmanhalalit/pixie 2.0.2 💰
A lightweight, expressive, framework agnostic query builder for PHP.
7 versions - Latest release: over 4 years ago - 20 dependent packages - 81 dependent repositories - 1.59 million downloads total - 671 stars on GitHub - 1 maintainer
Top 0.4% on packagist.org
j4mie/idiorm v1.5.8
A lightweight nearly-zero-configuration object-relational mapper and fluent query builder for PHP5
16 versions - Latest release: almost 2 years ago - 41 dependent packages - 384 dependent repositories - 1.22 million downloads total - 2,011 stars on GitHub - 3 maintainers
Top 5.5% on packagist.org
timgws/query-builder-parser 2.0.0
Build complex Eloquent & QueryBuilder queries automatically when using jQuery-QueryBuilder
20 versions - Latest release: 10 months ago - 10 dependent repositories - 290 thousand downloads total - 156 stars on GitHub - 1 maintainer
Top 5.4% on packagist.org
jasny/persist-sql-query v2.0.0
SQL Query builder and parser
3 versions - Latest release: over 9 years ago - 1 dependent package - 7 dependent repositories - 271 thousand downloads total - 33 stars on GitHub - 1 maintainer
Top 2.1% on packagist.org
lulco/phoenix 2.5.0
Database Migrations for PHP
41 versions - Latest release: 5 months ago - 6 dependent packages - 31 dependent repositories - 200 thousand downloads total - 164 stars on GitHub - 1 maintainer
Top 1.3% on packagist.org
nilportugues/sql-query-builder 1.8.0
An elegant lightweight and efficient SQL QueryInterface BuilderInterface supporting bindings and ...
16 versions - Latest release: about 4 years ago - 13 dependent packages - 52 dependent repositories - 189 thousand downloads total - 410 stars on GitHub - 1 maintainer
fobia/laravel-sphinx v2.0.1
A Laravel query builder for SphinxQL
10 versions - Latest release: over 2 years ago - 1 dependent repositories - 95.8 thousand downloads total - 29 stars on GitHub - 1 maintainer
koolreport/querybuilder 3.4.0
Create query by php code
15 versions - Latest release: 8 months ago - 1 dependent package - 1 dependent repositories - 71.9 thousand downloads total - 7 stars on GitHub - 1 maintainer
Top 2.7% on packagist.org
opis/database 4.2.1
A database abstraction layer over PDO, that provides a powerful and intuitive query builder, bund...
52 versions - Latest release: about 3 years ago - 6 dependent packages - 23 dependent repositories - 69.7 thousand downloads total - 98 stars on GitHub - 2 maintainers
cekurte/rql v0.0.5
A Resource Query Language to PHP
5 versions - Latest release: about 8 years ago - 1 dependent package - 2 dependent repositories - 60.1 thousand downloads total - 8 stars on GitHub - 1 maintainer
Top 5.7% on packagist.org
petkopara/multi-search-bundle v1.0.0
Symfony bundle for Multi Criteria Search for doctrine entities using Form or Service.
1 version - Latest release: over 7 years ago - 3 dependent packages - 18 dependent repositories - 58.4 thousand downloads total - 14 stars on GitHub - 1 maintainer
Top 8.1% on packagist.org
cfpinto/graphql v2.0.0
A GraphQL query builder class
18 versions - Latest release: over 1 year ago - 4 dependent packages - 3 dependent repositories - 51.8 thousand downloads total - 14 stars on GitHub - 1 maintainer
Top 3.0% on packagist.org
mrjgreen/database 2.6.0
Expressive Database Layer for PHP - Based on Illuminate/Database
19 versions - Latest release: almost 2 years ago - 12 dependent packages - 21 dependent repositories - 43.9 thousand downloads total - 54 stars on GitHub - 1 maintainer
jaqb/jaqb 1.2.1
Just Another Query Builder built on PDO
9 versions - Latest release: over 8 years ago - 1 dependent package - 1 dependent repositories - 36.6 thousand downloads total - 1 stars on GitHub - 1 maintainer
sqltools/where 1.4.2
PHP7.1 Fluent, immutable SQL query builder. Connectionless, framework-agnostic, no dependency.
9 versions - Latest release: over 1 year ago - 34.9 thousand downloads total - 0 stars on GitHub - 1 maintainer
wp-forge/wp-query-builder 1.0.3
A lightweight and efficient SQL query builder for WordPress.
4 versions - Latest release: about 1 year ago - 2 dependent repositories - 33.3 thousand downloads total - 1 stars on GitHub - 1 maintainer
Top 4.5% on packagist.org
ripaclub/sphinxsearch 0.8.1
Sphinx Search library provides SphinxQL indexing and searching features
13 versions - Latest release: about 8 years ago - 3 dependent packages - 8 dependent repositories - 31.2 thousand downloads total - 62 stars on GitHub - 2 maintainers
webfiori/database v0.8.10 💰
Database abstraction layer of WebFiori framework.
64 versions - Latest release: 20 days ago - 1 dependent package - 4 dependent repositories - 27 thousand downloads total - 5 stars on GitHub - 1 maintainer
Top 6.2% on packagist.org
jasny/dbquery-mysql v2.0.0
Query builder and parser for MySQL
2 versions - Latest release: over 9 years ago - 3 dependent packages - 4 dependent repositories - 24.9 thousand downloads total - 33 stars on GitHub - 1 maintainer
Top 4.4% on packagist.org
pecee/pixie 4.16.3
Lightweight, fast query-builder for PHP based on Laravel Eloquent but with less overhead.
62 versions - Latest release: 2 months ago - 5 dependent packages - 11 dependent repositories - 21.2 thousand downloads total - 38 stars on GitHub - 1 maintainer
gccloud/db-driver v1.0.3
CodeIgniter 3 Database Driver extension
7 versions - Latest release: almost 5 years ago - 12.9 thousand downloads total - 0 stars on GitHub - 1 maintainer
Top 9.4% on packagist.org
windwalker/query 4.1.2
Windwalker Query package
115 versions - Latest release: 4 months ago - 2 dependent packages - 11 dependent repositories - 12.4 thousand downloads total - 6 stars on GitHub - 1 maintainer
hemiframe/php-query-builder 2.0.2 💰
Powerful and lightweight PHP SQL Query Builder
14 versions - Latest release: about 1 month ago - 11.2 thousand downloads total - 8 stars on GitHub - 1 maintainer
10quality/wp-query-builder v1.0.13
Wordpress Query Builder class library for custom models and data querying.
17 versions - Latest release: over 1 year ago - 8.16 thousand downloads total - 33 stars on GitHub - 1 maintainer
cubettech/lacassa v1.1
Cassandra based query builder for laravel.
2 versions - Latest release: about 7 years ago - 1 dependent repositories - 7.92 thousand downloads total - 34 stars on GitHub - 1 maintainer
voku/idiorm v2.1.7
A lightweight nearly-zero-configuration object-relational mapper and fluent query builder for PHP5
19 versions - Latest release: over 7 years ago - 1 dependent package - 7.65 thousand downloads total - 7 stars on GitHub - 1 maintainer
ohanzee/database 0.1.2
Ohanzee component for database SQL queries and query building
3 versions - Latest release: over 9 years ago - 10 dependent repositories - 7.39 thousand downloads total - 3 stars on GitHub - 1 maintainer
diezeel/laravel-sphinx v0.5.0
A Laravel query builder for SphinxQL
11 versions - Latest release: over 4 years ago - 7.36 thousand downloads total - 0 stars on GitHub - 1 maintainer
shso/laravel-cassandra v1.1.2
Cassandra based query builder for laravel.
4 versions - Latest release: about 5 years ago - 2 dependent repositories - 6.36 thousand downloads total - 22 stars on GitHub - 1 maintainer
anax/database-query-builder v2.0.4
Anax Database Query Builder module, create queries through methods.
26 versions - Latest release: over 4 years ago - 2 dependent packages - 11 dependent repositories - 5.98 thousand downloads total - 1 stars on GitHub - 1 maintainer
anax/database-active-record v2.0.4
Anax Database Active Record module for model classes.
5 versions - Latest release: over 4 years ago - 8 dependent packages - 15 dependent repositories - 5.93 thousand downloads total - 0 stars on GitHub - 1 maintainer
bentools/where 1.1.1
PHP7.1 Fluent, immutable SQL query builder. Connectionless, framework-agnostic, no dependency.
7 versions - Latest release: about 6 years ago - 2 dependent packages - 2 dependent repositories - 5.09 thousand downloads total - 12 stars on GitHub - 1 maintainer
sultann/wp-query-builder v1.0.2
WP Query Builder is a lightweight and efficient SQL Query Builder based on wpdb for WordPress. It...
2 versions - Latest release: almost 4 years ago - 1 dependent repositories - 4.71 thousand downloads total - 69 stars on GitHub - 1 maintainer
davidecesarano/embryo-pdo 1.0.7
Embryo PDO is a PHP SQL query builder using PDO.
8 versions - Latest release: over 2 years ago - 2 dependent packages - 1 dependent repositories - 4.67 thousand downloads total - 8 stars on GitHub - 1 maintainer
aviat/query v4.1.0
Database Query Builder and Abstraction layer
13 versions - Latest release: about 1 year ago - 2 dependent packages - 3 dependent repositories - 3.26 thousand downloads total - 8 stars on GitHub - 1 maintainer
jaredtking/jaqb 1.2.1
Just Another Query Builder built on PDO
9 versions - Latest release: over 8 years ago - 3 dependent packages - 4 dependent repositories - 2.66 thousand downloads total - 1 stars on GitHub - 1 maintainer
megawilddaddy/simple-pdo-query-builder 1.3.3
Simple PDO Query Builder
8 versions - Latest release: almost 4 years ago - 2.64 thousand downloads total - 0 stars on GitHub - 1 maintainer
jimwins/titi v0.0.7 💰
A lightweight nearly-zero-configuration object-relational mapper and fluent query builder for PHP...
7 versions - Latest release: 3 months ago - 1 dependent repositories - 2.49 thousand downloads total - 2 stars on GitHub - 1 maintainer
artox-lab/fairy-database 1.1.3
A lightweight, expressive, framework agnostic query builder for PHP.
14 versions - Latest release: over 8 years ago - 2.49 thousand downloads total - 1 stars on GitHub - 2 maintainers
n30fly/pixie 2.0.0
A lightweight, expressive, framework agnostic query builder for PHP.
4 versions - Latest release: about 8 years ago - 2.48 thousand downloads total - 0 stars on GitHub - 1 maintainer
zk2/sps-dbal-component v2.0.3
SQL query builder for Doctrine DBAL
23 versions - Latest release: about 1 month ago - 2.41 thousand downloads total - 0 stars on GitHub - 1 maintainer
aviat4ion/query v2.5.1
Database Query Builder and Abstraction layer
9 versions - Latest release: almost 9 years ago - 1 dependent package - 10 dependent repositories - 1.89 thousand downloads total - 8 stars on GitHub - 1 maintainer
symftony/xpression
Xpression is a simple PHP implementation of Specification pattern
Latest release: 29 days ago - 1 dependent repositories - 1.84 thousand downloads total - 15 stars on GitHub - 1 maintainer
stevenmaguire/laravel-cache 1.0.0 💰
Seamlessly adding caching to Laravel service objects
7 versions - Latest release: over 8 years ago - 1.76 thousand downloads total - 17 stars on GitHub - 1 maintainer
finesse/query-scribe v0.9.3
Light SQL query builder designed for extensibility and flexibility
14 versions - Latest release: over 5 years ago - 1 dependent package - 1 dependent repositories - 1.69 thousand downloads total - 1 stars on GitHub - 1 maintainer
masnathan/sql-query-builder v1.1.1
An elegant lightweight and efficient SQL QueryInterface BuilderInterface supporting bindings and ...
5 versions - Latest release: almost 9 years ago - 1.59 thousand downloads total - 0 stars on GitHub - 1 maintainer
pthreat/sql-query-builder 1.0.4
SQL QueryInterface BuilderInterface supporting bindings and complex query generation.
5 versions - Latest release: over 1 year ago - 1.47 thousand downloads total - 1 stars on GitHub - 1 maintainer
xtompie/aql 5.0.0
Array Query Language - building a SQL using array
12 versions - Latest release: 2 months ago - 1 dependent package - 1 dependent repositories - 1.36 thousand downloads total - 0 stars on GitHub - 1 maintainer
finesse/mini-db v0.7.4
Light database abstraction with a query builder
13 versions - Latest release: over 5 years ago - 1 dependent package - 1 dependent repositories - 1.29 thousand downloads total - 3 stars on GitHub - 1 maintainer
anthonyedmonds/laravel-find 4.0.1
Find models within your Laravel system with minimal overhead
12 versions - Latest release: 17 days ago - 1.27 thousand downloads total - 0 stars on GitHub - 1 maintainer
monii/specification-sql-adapter
Specification SQL Adapter
Latest release: 18 days ago - 1.22 thousand downloads total - 1 maintainer
cfpinto/shopify-graphql 0.0.8
A GraphQL wrapper for shopify graphql api
9 versions - Latest release: over 6 years ago - 1.08 thousand downloads total - 1 stars on GitHub - 1 maintainer
zk2/sps-component v1.5.2
SQL/DQL query builder for Doctrine 2
34 versions - Latest release: over 3 years ago - 1 dependent package - 1 dependent repositories - 952 downloads total - 2 stars on GitHub - 1 maintainer
kyrax324/laravel-queriplex v2.0.1
A simple package to help building query builder between request inputs and allowed rules.
4 versions - Latest release: over 1 year ago - 952 downloads total - 3 stars on GitHub - 1 maintainer
cloudmanic/database
A simple query builder for mysql.
Latest release: about 1 month ago - 5 dependent repositories - 931 downloads total - 1 stars on GitHub - 1 maintainer
davewid/peyote 0.7.2
A database query builder for PHP 5.3+
11 versions - Latest release: over 10 years ago - 2 dependent packages - 10 dependent repositories - 827 downloads total - 15 stars on GitHub - 1 maintainer
ludal/mysql-querybuilder v0.5.2
A simple PHP query builder for SQL queries
11 versions - Latest release: over 2 years ago - 1 dependent package - 2 dependent repositories - 741 downloads total - 14 stars on GitHub - 1 maintainer
woohoolabs/larva 0.7.3
Woohoo Labs. Larva Database Abstraction
11 versions - Latest release: almost 4 years ago - 1 dependent package - 1 dependent repositories - 691 downloads total - 2 stars on GitHub - 1 maintainer
romeoz/rock-mongodb 0.15.0
Object Document Mapper (ODM) for MongoDB.
9 versions - Latest release: over 8 years ago - 2 dependent packages - 6 dependent repositories - 659 downloads total - 1 stars on GitHub - 1 maintainer
sbovyrin/repo 2.3.4
Language to talk with your repository
8 versions - Latest release: almost 3 years ago - 650 downloads total - 1 maintainer
velvel/report-bundle
Online database report generator for Symfony2
Latest release: 24 days ago - 4 dependent repositories - 582 downloads total - 17 stars on GitHub - 1 maintainer
mapbender/query-builder 1.2.4
Mapbender query builder element
13 versions - Latest release: over 1 year ago - 557 downloads total - 1 stars on GitHub - 2 maintainers
tomrf/conform 0.1.1
pdo sql query builder and executor
9 versions - Latest release: about 2 years ago - 537 downloads total - 1 stars on GitHub - 1 maintainer
finesse/wired v0.7.2
Light standalone ORM with a query builder and no external configuration
11 versions - Latest release: about 5 years ago - 522 downloads total - 1 stars on GitHub - 1 maintainer
deimos/query-builder 0.0.4
Deimos Query Builder.
27 versions - Latest release: over 7 years ago - 1 dependent package - 1 dependent repositories - 507 downloads total - 0 stars on GitHub - 1 maintainer
diversen/minimal-query-builder v1.1.1
A simple and very basic query builder class, which should support any database supported by PDO.
8 versions - Latest release: over 5 years ago - 2 dependent packages - 2 dependent repositories - 505 downloads total - 1 stars on GitHub - 1 maintainer
toanld/sphinx-query 2.1.2
A PHP query builder for SphinxQL. Uses MySQLi to connect to the Sphinx server.
35 versions - Latest release: about 2 years ago - 434 downloads total - 0 stars on GitHub - 1 maintainer
gales-petkopara/multi-search-bundle v2.0.4
Symfony bundle for Multi Criteria Search for doctrine entities using Form or Service.
5 versions - Latest release: 9 months ago - 1 dependent package - 1 dependent repositories - 406 downloads total - 0 stars on GitHub - 1 maintainer
gos/doctrine-query-builder
Keep your repository healthy !
Latest release: 6 days ago - 4 dependent repositories - 365 downloads total - 1 stars on GitHub - 1 maintainer
gin0115/pixie-wpdb 0.0.3
An adaptation of Pixie (created byusmanhalalit) for WordPress using WPDB over PDO.
6 versions - Latest release: about 2 years ago - 294 downloads total - 2 stars on GitHub - 1 maintainer
codesvault/howdy-qb 1.6.2
Mysql Query Builder for WordPress
16 versions - Latest release: 3 months ago - 1 dependent package - 3 dependent repositories - 285 downloads total - 18 stars on GitHub - 2 maintainers
traineratwot/pdo-extended 2.1.2
40 versions - Latest release: over 1 year ago - 1 dependent package - 2 dependent repositories - 278 downloads total - 0 stars on GitHub - 1 maintainer
plugin-master/db 1.0.8
The query builder for WordPress
13 versions - Latest release: over 2 years ago - 1 dependent package - 2 dependent repositories - 254 downloads total - 0 stars on GitHub - 1 maintainer
acburdine/pixie-backports v1.1.1
A lightweight, expressive, framework agnostic query builder for PHP. Contains backports for PHP 5.3
5 versions - Latest release: almost 8 years ago - 252 downloads total - 0 stars on GitHub - 1 maintainer
uhi67/uxapp 1.8.3
XSLT-based MVC framework
17 versions - Latest release: 6 months ago - 6 dependent packages - 6 dependent repositories - 252 downloads total - 1 maintainer
nochso/orm 1.3.5
ORM with relations and performance in mind.
10 versions - Latest release: over 8 years ago - 1 dependent repositories - 249 downloads total - 0 stars on GitHub - 1 maintainer
jasny/dbquery v1.0.0
The best and most complete query builder/parser (for MySQL)
1 version - Latest release: over 10 years ago - 1 dependent package - 4 dependent repositories - 248 downloads total - 1 maintainer
bazo/neo4j-tools
Neo4j tools extracted from lphuberdeaus neo4j-php-ogm
Latest release: 2 days ago - 4 dependent repositories - 240 downloads total - 1 stars on GitHub - 1 maintainer
xinningsu/laravel-raw-sql v1.0
Get raw sql from laravel query builder via toRawSql method.
1 version - Latest release: over 3 years ago - 230 downloads total - 0 stars on GitHub - 1 maintainer
webvimark/pixie 2.1.17
A lightweight, expressive, framework agnostic query builder for PHP.
45 versions - Latest release: about 4 years ago - 229 downloads total - 0 stars on GitHub - 1 maintainer
requtize/query-builder 1.0.1
Fast, simple and dependency-free query builder for PHP.
1 version - Latest release: over 5 years ago - 1 dependent repositories - 226 downloads total - 17 stars on GitHub - 1 maintainer
nethask/sphinxql-query-builder 1.0.0
A PHP query builder for SphinxQL. Uses MySQLi to connect to the Sphinx server.
1 version - Latest release: over 5 years ago - 221 downloads total - 0 stars on GitHub - 1 maintainer
jackardios/laravel-query-wizard v1.0.1
Laravel Query Wizard
5 versions - Latest release: 3 months ago - 1 dependent package - 2 dependent repositories - 220 downloads total - 0 stars on GitHub - 1 maintainer
phuria/under-query-bundle 0.2.1
Symfony integration bundle for UnderQuery
3 versions - Latest release: over 7 years ago - 216 downloads total - 2 stars on GitHub - 1 maintainer
hraw/dbqb v1.0.1
A lightweight mysql query builder for PHP
3 versions - Latest release: almost 2 years ago - 209 downloads total - 1 stars on GitHub - 1 maintainer
phpvv/db 0.3.0
VV database abstraction layer with query builder and DB structure models
14 versions - Latest release: over 2 years ago - 4 dependent packages - 4 dependent repositories - 192 downloads total - 0 stars on GitHub - 1 maintainer
tomrf/seminorm 0.0.7
pdo sql query builder and executor
7 versions - Latest release: about 1 year ago - 181 downloads total - 0 stars on GitHub - 1 maintainer
jackardios/elastic-query-wizard v1.0.2
Laravel Elastic Query Wizard
8 versions - Latest release: 3 months ago - 180 downloads total - 0 stars on GitHub - 1 maintainer
mvcbox/sql-query
Query Builder
Latest release: about 1 month ago - 176 downloads total - 1 maintainer
veryard/sql-query-builder
An elegant lightweight and efficient SQL QueryInterface BuilderInterface supporting bindings and ...
Latest release: 5 days ago - 170 downloads total - 0 stars on GitHub - 1 maintainer
ajowsentry/sqltark-7 v0.9.23
SQL Query Builder for PHP
14 versions - Latest release: 4 months ago - 169 downloads total - 0 stars on GitHub - 1 maintainer
chezrd/idiorm v1.5.7
A lightweight nearly-zero-configuration object-relational mapper and fluent query builder for PHP...
15 versions - Latest release: about 1 year ago - 164 downloads total - 0 stars on GitHub - 1 maintainer
nabcellent/codeigniter4-eloquent v1.1.7
The Illuminate/Eloquent package for CodeIgniter 4.
12 versions - Latest release: over 2 years ago - 143 downloads total - 1 stars on GitHub - 1 maintainer
phpvv/db-pdo 0.3.0
VV DB Driver over PDO extension
8 versions - Latest release: over 2 years ago - 134 downloads total - 0 stars on GitHub - 1 maintainer
naga3/qb 1.0.7
Qb: Simple query builder
8 versions - Latest release: over 8 years ago - 116 downloads total - 8 stars on GitHub - 1 maintainer
timgws/cleanhtml
Quickly & Easily clean out HTML text, making sure that only the bare minimum is left behind
Latest release: 3 days ago - 115 downloads total - 6 stars on GitHub - 1 maintainer
serdartaylan/laravel-sphinx v1.3.1
A Laravel query builder for SphinxQL
14 versions - Latest release: over 1 year ago - 107 downloads total - 0 stars on GitHub - 1 maintainer
jinnguyen/puja-sqlbuilder v1.2.0
Puja-SqlBuilder allows users to build quickly and easily complex
3 versions - Latest release: over 6 years ago - 1 dependent package - 1 dependent repositories - 107 downloads total - 0 stars on GitHub - 1 maintainer
met_mw/squerybuilder v1.0.0
Simple query builder.
1 version - Latest release: over 7 years ago - 1 dependent package - 1 dependent repositories - 105 downloads total - 0 stars on GitHub - 1 maintainer
Related Keywords
database 101 sql 93 mysql 71 query 43 php 41 pdo 37 orm 36 sqlite 31 laravel 31 query-builder 28 builder 25 postgresql 24 eloquent 13 sphinx 12 cql 12 cassandra 12 nosql 12 sphinxql 11 db 10 dbal 9 idiorm 9 search 8 parser 8 querybuilder 7 mongodb 7 wordpress 6 ajax 6 doctrine 6 jquery 6 library 5 Abstraction Layer 5 mysqli 5 crud 5 php7 4 pdo-mysql 4 Sphinx Eloquent 4 framework 4 postgres 4 Active Record 4 schema builder 3 oracle 3 filter 3 lumen 3 php-library 3 graphql 3 php8 3 SQL Builder 3 codeigniter 3 models 3 pixie 3 sql-query-builder 3 jackardios 3 laravel-query-builder 3 json api 3 wizard 3 api 3 json 3 postgre 3 yii2 2 hacktoberfest 2 lara-cass 2 cache 2 query-executor 2 pecee 2 ElePHPant 2 pgsql 2 query-generator 2 firebird 2 elephant 2 sqlite3 2 mariadb 2 Simple 2 shopify 2 Query builder for WordPress 2 lacassa 2 dba 2 specification 2 query generator 2 activerecord 2 WordPress Query Builder 2 laravel-package 2 sqlbuilder 2 json-api 2 criteria 2 symfony3 2 multi-search 2 scout 2 jaqb 2 update 2 case 2 insert 2 indexing 2 select 2 delete 2 field 2 search engine 2 zf2 2 where 2 conditions 2 then 2