Weave Code
Weaver
Helps Laravel developers discover, compare, and choose open-source packages. See popularity, security, maintainers, and scores at a glance to make better decisions.
Feedback
Share your thoughts, report bugs, or suggest improvements.
Subject
Message

Laravel Sub Query Laravel Package

alexmg86/laravel-sub-query

alexmg86/laravel-sub-query brings fluent subquery support to Laravel's query builder and Eloquent, letting you embed subqueries in SELECT, FROM, WHERE, JOIN, and ORDER BY clauses through a clean, chainable API.

View on GitHub
Deep Wiki
Context7

Product Decisions This Supports

  • Feature prioritization: The release adds whereCurrentYear, whereCurrentMonth, and whereCurrentDay convenience methods. This supports small, high-frequency product improvements around “current period” filters in dashboards, admin views, exports, and operational queues.
  • Roadmap enablement: These methods can accelerate delivery of analytics widgets, recurring reports, and time-based filters without custom query scopes for each model. Treat this as an enabler, not a standalone roadmap item.
  • Build vs. buy: If the package is already in the stack, prefer these methods over duplicating local date-filter logic. If not yet adopted, weigh a new dependency against writing a few local Eloquent scopes; this release alone is unlikely to justify adoption.
  • Use cases: Current-year revenue or signups, current-month orders or subscriptions, current-day jobs or support tickets, and recurring KPI reporting.
  • Standardization: Encourages consistent “current period” semantics across models, but the team must explicitly define timezone behavior, boundaries, and whether “current” means calendar period vs. fiscal period.

When to Consider This Package

  • Consider it when the application uses Laravel/Eloquent and repeatedly needs current-day, current-month, or current-year filters across multiple models or features.
  • Adopt when the package is already maintained in the stack, the release is additive, and the team can verify timezone handling, database compatibility, test coverage, and query performance.
  • Use it for low-risk product acceleration: admin filters, reporting views, scheduled summaries, and internal operational tooling.
  • Look elsewhere or write local scopes when there are only one or two date-filter use cases, the product needs complex fiscal calendars or multi-timezone reporting semantics, reporting is handled primarily in a warehouse/BI tool, or the package lacks maintenance and compatibility guarantees.

How to Pitch It (Stakeholders)

  • Executives: This is a small, additive release that reduces custom code for common time-based filters. It is low-risk and can speed up reporting and admin features, but it is not a strategic differentiator on its own.
  • Engineering: The new methods provide convenience scopes for current year/month/day. Before broad use, confirm timezone and boundary behavior, add tests for edge cases, and check indexes/query plans for date-filtered queries. No breaking changes are apparent from the release notes.
  • Product: Use this to accelerate common “current period” views and exports, but keep scope focused. It is best treated as plumbing that helps teams ship recurring reporting and operational filters faster.
Weaver

How can I help you explore Laravel packages today?

Conversation history is not saved when not logged in.
Prompt
Add packages to context
No packages found.
adachsoft/changelog-linter
adachsoft/collection
payerurl/telegrambot-crypto-payment-instant-payout
dskripchenko/laravel-hybrid-search
riorizkyrainey/lara-ced
mehedimi/static-vel
zharp/zharp
nonsapiens/bigquery-model-sync
lgu-bayambang-ict-office/lgu-laravel-development-standards
andydefer/laravel-support
se7enxweb/flysystem
lampwick/laravel
jeslage/statamic-emojis
micahdshackelford/rmap-laravel
draftsmaninc/draftsman
square-bit/laravel-volition
himito/laravel-mailman
htinlynn/genius-helper
maco-studios/hephaestus
elmogy/larafast