search

rails / arel

A Relational Algebra
2.06k stars 390 forks source link

Add support for FILTER clause (SQL:2003) #518

Closed Envek closed 6 years ago

Envek commented 6 years ago

Closes #460

Currently supported only by PostgreSQL 9.4 and newer.

See:

Example (ActiveRecord):

Model.all.pluck(
  Arel.star.count.as('records_total'),
  Arel.star.count.filter(Model.arel_table[:some_column].not_eq(nil)).as('records_filtered'),
)
rails-bot commented 6 years ago

Thanks for the pull request, and welcome! The Rails team is excited to review your changes, and you should hear from @sgrif (or someone else) soon.

If any changes to this PR are deemed necessary, please add them as extra commits. This ensures that the reviewer can see what has changed since they last reviewed the code. Due to the way GitHub handles out-of-date commits, this should also make it reasonably obvious what issues have or haven't been addressed. Large or tricky changes may require several passes of review and changes.

Please see the contribution instructions for more information.

matthewd commented 6 years ago

Per #523, Arel development is moving to rails/rails.

If this PR is still relevant, please consider reopening it over there.

paulwalker commented 3 years ago

@Envek can you please consider moving the pull request to rails/rails?

Envek commented 3 years ago

Reopened in https://github.com/rails/rails/pull/40491