Query Laravel Package

Product Decisions This Supports

• Unified Query Abstraction: Enables cross-database consistency (MySQL, PostgreSQL, SQLite, SQL Server) for teams managing multi-database environments, reducing SQL dialect fragmentation.
• Roadmap for Database Agnosticism: Supports future-proofing by abstracting away vendor-specific SQL syntax, easing migrations or multi-cloud deployments.
• Build vs. Buy: Avoids reinventing query builders (e.g., Eloquent-like syntax) while offering more flexibility than ORMs for complex raw queries.
• Use Cases:
  • Data Pipelines: Build reusable query logic for ETL or analytics.
  • Admin Panels: Dynamic table/column filtering with consistent syntax.
  • Legacy System Integration: Standardize queries across heterogeneous databases.

When to Consider This Package

• Adopt if:
  • Your team needs cross-database query consistency without ORM overhead.
  • You’re building complex raw queries (e.g., unions, subqueries) that ORMs can’t handle elegantly.
  • You require fine-grained control over SQL generation (e.g., for performance tuning or stored procedures).
  • Your stack already uses Atlas.Pdo (dependency) or you’re open to adopting it.
• Look elsewhere if:
  • You prioritize active maintenance (last release: 2021; no dependents).
  • Your team prefers ORM features (e.g., relationships, migrations) over raw query builders.
  • You need modern PHP features (e.g., attributes, enums) or type safety (package lacks PHPDoc types).
  • Your database is not supported (e.g., Oracle, MariaDB).

How to Pitch It (Stakeholders)

Executives: "Atlas.Query standardizes SQL across our databases (MySQL, PostgreSQL, etc.), reducing errors and maintenance costs. It’s a lightweight, MIT-licensed tool that lets our engineers write complex queries once—without vendor lock-in. Ideal for data-heavy projects like [X Initiative]."

Engineering: *"This gives us a fluent, object-oriented query builder (like Eloquent but for raw SQL). Key benefits:

• Cross-database portability: Write queries once, deploy anywhere.
• Performance: Direct SQL generation with no ORM abstraction penalty.
• Extensibility: Supports custom query classes or unions. Tradeoff: Less active than Laravel’s Eloquent, but more flexible for edge cases. Recommended for [Y Module] where we need [Z Feature]."*

Devs: *"Need to write a complex UNION query or handle dynamic table names? This package lets you chain methods like:

$users = Select::from('users')
    ->whereEquals('active', true)
    ->union(Select::from('admins')->whereEquals('status', 'active'))
    ->limit(10);

Works with Atlas.Pdo—no PDO mess. Docs are solid, but expect no updates post-2021."*