v2.0.0

📢 FiQueLa 2.0.0 is Out! 🎉

The final release of FiQueLa 2.0.0 is here, delivering a fully refactored core, powerful new features, and rock-solid stability for querying structured file data with ease and elegance. 🚀

💬 Feedback Welcome!
FiQueLa 2.0.0 is the most stable, capable, and extensible version to date. Your feedback will help drive the future of file querying in PHP.

👉 Get Started:
composer require 1biot/fiquela

👉 Report issues or request features on GitHub Issues: https://github.com/1biot/FiQueLa/issues

Thanks for being part of this journey.
Let’s continue shaping the future of file-based data processing — one query at a time. 💪

v2.0.0-rc3

📢 FiQueLa 2.0.0-rc3 is Here! 🚀

• Fixed comparing base paths at sql parser

V2.0.0-rc2

📢 FiQueLa 2.0.0-rc2 is Here! 🚀

More information at main page. Added new format ndjson and fex improvements with excluding fields from select and adding basepath to sql query parser

v2.0.0-rc

📢 FiQueLa 2.0.0-rc is Here! 🚀

More information at main page

2.0.0-beta

📢 FiQueLa 2.0.0-beta is Here! 🚀

We’re excited to announce FiQueLa 2.0.0-beta, a massive update with groundbreaking improvements and new features to take file querying to the next level! 🎉

🌟 Highlights of 2.0.0-beta

1️⃣ Renamed and Reimagined

• The library has been renamed from UniQueL to FiQueLa, better reflecting its purpose.
• The namespace has changed from UQL to FQL.

2️⃣ Core Enhancements

• Code Overhaul: Most of the code has been rewritten for better performance and maintainability.
• New JSON Stream Parser: The FQL\Stream\JsonStream class enables efficient JSON parsing as a stream.
• New Features for SQL-inspired Queries:
  • Support for the DISTINCT clause.
  • Grouping capabilities via the GROUP BY clause (now compatible with aggregate functions like COUNT, SUM, AVG, and more).

3️⃣ Powerful Functions

• Added new aggregate functions: COUNT, SUM, AVG, MIN, MAX, and GROUP_CONCAT.
• Support for new utility functions:
  • BASE64_DECODE, BASE64_ENCODE for encoding and decoding.
  • RANDOM_STRING, RANDOM_BYTES for random data generation.
• Improved functionality for WHERE and HAVING clauses.

4️⃣ Enhanced SQL-like Parser

• Rapidly Improved SQL Parser: The SQL-like parser has been significantly upgraded.
  • It can now be used independently, without requiring an already open file.
  • Ideal for single-use queries without any complications.

5️⃣ Enhanced Testing and Benchmarking

• Refactored the test namespace to comply with PSR-4 standards.
• Added benchmarking tests for query performance analysis.
• Added more then 100 tests and almost 300 assertions

📖 Improved Documentation

• Comprehensive documentation with examples of new features and use cases.
• Tutorials covering fulltext search, aggregate functions, and file stream processing.
• Updated CLI guides to help developers quickly get started with FiQueLa.

💬 Feedback Welcome!

As this is a beta release, we encourage the FiQueLa community to provide feedback. Test the new features, report bugs, and help shape the final release!

👉 Get Started:

composer require 1biot/fiquela

👉 Submit Feedback: GitHub Issues

Thank you for being part of this journey! Together, we’re redefining file querying, one feature at a time. 💪

1.5.0

🎉 UniQueL v1.5.0 Released! 🎉

Introducing UniQueL v1.5.0, a release that expands functionality and improves the developer experience. 🚀

🔥 What’s New in v1.5.0?

1. Support for CSV File Queries

   • UniQueL now supports querying data directly from CSV files, in addition to JSON, XML, YAML, and NEON.

2. Data Transformation Functions

   • Added a range of functions for refining and transforming selected data, including coalesce, concat, round, lower, upper, and many more.
   • See the full list of supported functions in the README.

3. Improved Testing for Traits

   • Tests for traits have been refactored to better isolate and evaluate their functionality.
   • This work is ongoing, but it provides a more robust foundation for testing.

4. Expanded Test Suite

   • A new set of tests has been added, increasing coverage and ensuring stability across various use cases.

🚀 Upgrade Now!

Run the following command to update to the latest version:

composer update 1biot/uniquel

As always, your feedback and contributions are welcome! Explore the new features and let us know what you think. ✨

1.4.2

I hope that this fix the version. :-)

1.4.1

Fixed version at composer

1.4.0

🆕 What's New in 1.4.0
I have fixed the iteration of XML files, which had issues when reusing the fetchAll method.
Additionally, I've added a Debugger for inspecting queries themselves.
Finally, I expanded the usage examples to provide better clarity and guidance.

1.3.0

This update introduces data joining capabilities, allowing you to combine datasets seamlessly using SQL-like JOIN operations. Whether you're working with JSON, XML, YAML, or NEON, you can now enrich your queries with powerful JOIN functionality.

🆕 What's New in 1.3.0

1. JOIN Support

• Added support for INNER JOIN and LEFT JOIN.
• Join datasets from multiple sources, including inline arrays or other queries.
• Utilize SQL-like syntax with the on method to define join conditions:

$query->join($ordersQuery, 'o')
  ->on('userId', Operator::EQUAL, 'orderUserId');

• Supports aliasing to avoid field name conflicts:

$query->join($ordersQuery, 'orders');

2. Enhanced SQL-like Representation

• Supports only SQL output. String parser has no ability to parse joins. It's comes in future versions.
• Example output:

INNER JOIN (SELECT orderUserId, order_id FROM orders) AS o ON userId = orderUserId

3. Improved Query Flexibility

• Joins now work seamlessly with nested queries, ensuring robust and efficient data merging for complex datasets.

🛠 Bug Fixes

• Fixed minor issues related to OFFSET and LIMIT.

📚 Documentation Update

• See full details in the updated README.

Happy coding! ✨