FiQueLa (File Query Language, pronounced fi-kju-ela) is a PHP library that brings SQL-style querying to file-based data. Filter, join, group, aggregate, and transform records from XML, CSV, JSON, YAML, NEON, NDJSON, XLS, ODS files, and HTTP access logs using either a fluent PHP API or an FQL string — all without setting up a database.Documentation Index
Fetch the complete documentation index at: https://docs.fiquela.io/llms.txt
Use this file to discover all available pages before exploring further.
Key features
- Multiple formats: XML, CSV, JSON, NDJSON, YAML, NEON, XLS, ODS files, and HTTP access logs in a single unified API.
- SQL-inspired syntax:
SELECT,WHERE,JOIN,GROUP BY,HAVING,ORDER BY,LIMIT, and more. - Two query styles: Write queries as FQL strings or chain methods with the fluent PHP API.
- Powerful expressions:
CASE WHEN,IF, nested condition groups,XOR,REGEXP, aggregate functions, and utility functions likeROUND,EXPLODE,MOD. - Stream-first processing: Large JSON, XML, and CSV files are processed with low memory overhead wherever possible.
- DTO mapping: Map result rows directly to typed PHP objects.
- Debug tooling: Built-in
Query\Debuggerwith explain plans and benchmarking.
When to use FiQueLa
FiQueLa is a good fit when:- You need to extract or analyze data from structured files without importing them into a database.
- You want to join or aggregate data across multiple files or formats in a single query.
- You are building lightweight data processing pipelines entirely in PHP.
- You need to inspect or transform files during development, scripting, or ETL tasks.
Get started
Installation
Install FiQueLa via Composer and configure required PHP extensions.
Quickstart
Run your first query against a file in under five minutes.
Fluent API
Chain PHP methods to build expressive, readable queries.
FQL syntax
Write SQL-like strings to query files directly.