Dql Bundle Laravel Package

Product Decisions This Supports

• Feature Expansion for Legacy Systems: If your product relies on legacy PHP/Symfony applications with outdated MySQL function support, this package could bridge gaps in date/time handling without rewriting queries.
• Cost-Effective Customization: A lightweight, MIT-licensed solution for adding missing MySQL functions (e.g., DATE, MONTH, YEAR) to Doctrine queries, reducing dependency on proprietary extensions.
• Roadmap for Data-Driven Features: Enables faster development of time-based analytics, reporting, or scheduling features by simplifying query syntax (e.g., SELECT MONTH(created_at)).
• Build vs. Buy: Justified as a "buy" for teams already using Laravel/Symfony, avoiding reinventing wheel for basic MySQL extensions.
• Use Cases:
  • Internal tools needing ad-hoc SQL queries with date functions.
  • Migration projects where Doctrine lacks native support for certain MySQL functions.
  • Prototyping phases where quick, non-critical extensions are needed.

When to Consider This Package

• Adopt When:
  • Your team uses Symfony/Laravel with Doctrine DBAL and needs missing MySQL functions (e.g., DAYOFWEEK, QUARTER).
  • You’re working with legacy databases where schema changes are costly, and query-level fixes are preferable.
  • The package’s MIT license aligns with your open-source policy.
  • Your PHP version is ≥5.3.2 (though newer versions are strongly recommended).
• Look Elsewhere If:
  • You’re using PostgreSQL/SQLite, as this is MySQL-specific.
  • Your project requires enterprise-grade support (this package has 0 stars/dependents and appears unmaintained).
  • You need complex functions (e.g., window functions) or active maintenance—consider native MySQL extensions or Doctrine’s ExpressionBuilder.
  • Your team prefers modern PHP (≥8.0); compatibility is untested for newer versions.

How to Pitch It (Stakeholders)

For Executives: "This lightweight, open-source package lets us add missing MySQL date functions (like MONTH() or YEAR()) to our Symfony/Laravel queries without rewriting core logic. It’s a quick win for legacy systems or rapid prototyping—think of it as ‘Lego blocks’ for SQL queries. Since it’s MIT-licensed and free, it reduces vendor risk while keeping costs low. Ideal for internal tools or migration projects where we need to move fast."

For Engineering: "The baetmaen/dql-bundle extends Doctrine’s query capabilities with MySQL functions not natively supported. For example, instead of writing raw SQL, we can use ->expr()->func('MONTH', 'created_at') in queries. It’s a drop-in for teams stuck with outdated MySQL setups. Caveats:

• Unmaintained (last commit likely years old)—vet thoroughly.
• MySQL-only; not a replacement for full ORM features.
• Test compatibility with PHP ≥5.3.2 (preferably 7.4+). Best for short-term fixes or legacy codebases where query-level patches are cheaper than schema changes."