QueryBuilder can be used on advanced search engine pages, administration backends, etc. to build complex queries or filters. It is highly customisable and can be used with many jQuery widgets like autocompleters and sliders.
It outputs a structured JSON of rules which can be easily parsed to create SQL/NoSQL/whatever queries.
"Nesting performs a join across two buckets. But instead of producing a cross-product of the left and right hand inputs, a single result is produced for each left hand input, while the corresponding right hand inputs are collected into an array and nested as a single array-valued field in the result object."
The Doctrine Project is the home to several PHP libraries primarily focused on database storage and object mapping. The core projects are a Object Relational Mapper (ORM) and the Database Abstraction Layer (DBAL) it is built upon.
Couchbase Query Language, known as N1QL and pronounced "Nickel", is a query language for finding data in Couchbase Server. N1QL is designed to be human readable and writable. It is a language designed for ad-hoc querying. The query language is a standard semantic used to build querying ability in other databases.
Espresso provides an API as soon as you register your database. It introspects the database schema and populates the repository with the required metadata. Each table becomes a REST endpoint with services such as pagination, filtering, and optimistic locking out-of-the-box.
C. Batini, T. Catarci, M. Costabile, und S. Levialdi. Proceedings of the IFIP TC2/WG 2.6 Second Working Conference on Visual Database Systems II, Seite 153--168. Amsterdam, The Netherlands, The Netherlands, North-Holland Publishing Co., (1992)
B. Howe, G. Cole, N. Khoussainova, und L. Battle. Proceedings of the 2011 ACM SIGMOD International Conference on Management of data, Seite 1319--1322. New York, NY, USA, ACM, (2011)
K. Rohloff, und R. Schantz. Proceedings of the fourth international workshop on Data-intensive distributed computing, Seite 35--44. New York, NY, USA, ACM, (2011)