Download the PHP package ddbase3/php-struql without Composer
On this page you can find all versions of the php package ddbase3/php-struql. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package php-struql
Struql – Structured Query Logic for PHP
Struql is a modular, extensible, and phase-based query processing framework for PHP. It empowers developers to define, normalize, simplify, and compile structured query logic into executable SQL – all using a clean and extensible handler-based architecture.
🌐 Why Struql?
Struql was designed to solve a recurring problem: building highly dynamic and structured queries without tying your code to SQL strings or rigid query builders. With Struql, you can:
- Parse structured query inputs from users or APIs
- Normalize and enrich the query logic
- Automatically resolve joins and field variants
- Generate safe and dialect-specific SQL queries
📦 Features
- Four processing phases: Parse → Normalize → Simplify → Compile
- Handler architecture: Each transformation is modular and isolated
- JOIN auto-resolution: Based on smart field inference
- SQL dialect support: MySQL, MSSQL, PostgreSQL
- Composable processors: Reusable across contexts
- Readable, testable, and extendable code
🧱 Architecture Overview
Each phase is managed by a Processor, which consists of ordered Handlers. A handler is a class that inspects and transforms the query object for a specific purpose.
🧩 Key Concepts
✅ Processors and Handlers
Each handler must implement:
supportedTypes()– which input types it processesrun(mixed $input, array &$context): mixed– transformation logic
🧠 Phase Responsibilities
| Phase | Purpose |
|---|---|
parse |
Parses external input (e.g. query strings) into PHP objects |
normalize |
Expands shorthand field syntax, dollar-fields, top-level filters |
simplify |
Resolves aliases, inferred joins, expands derived objects |
compile |
Transforms the object into executable SQL |
🧪 Example Usage
Output SQL:
🛠️ Built-in Handlers
Normalize Phase
DollarFieldToFieldHandler: Converts$table!variant.fieldtofieldobjects withtable,name, andvariantFieldsToWhereHandler: Converts top-level field-value pairs towhereconditions
Compile Phase
-
SqlCompilerHandler: Converts normalized query objects to SQL strings; supports:- Joins (INNER, LEFT)
- Conditions with
AND,OR,NOT - ORDER BY, GROUP BY, HAVING, LIMIT, OFFSET
- Dialect-specific quoting
🔄 Extending Struql
To add a new transformation or compiler step, create a new handler:
Register it in your processor:
🚀 Use Cases
- Backend APIs that accept dynamic filters from users (e.g. dashboards, analytics)
- Middleware layers that convert API calls to database queries
- CMS systems with dynamic content filtering
- Query conversion pipelines for SQL dialect adaptation
📁 File Structure
📋 Future Plans
- ✅ Automatic join resolution via used fields
- 🔲 Validation layer for input checking before compilation
- 🔲 Support for INSERT, UPDATE, DELETE queries
- 🔲 Full support for subqueries and expressions
📃 License
This project is open-source and available under the MIT License.
🤝 Contributing
Contributions are welcome! Create a feature branch and submit a pull request. Please include tests where applicable.
🧠 Summary
Struql is a powerful and extensible query transformation engine. Its handler-based architecture allows developers to fully control and customize every aspect of query interpretation and SQL generation – from API input to final query execution.
Ideal for teams building APIs, dashboards, CMS backends, or data-driven platforms.
