We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
FILTER
SELECT
In SQL we can add a FILTER clause to an aggregate SELECT clause, i.e.
SELECT [item], SUM([price]) AS [total], SUM([price]) FILTER ( WHERE [date] >= '2021-01-01' ) AS [sales2020] FROM [orders] GROUP BY [item]
It would be a huge help if SqlKata can support passing WHERE clauses with their bindings to a SELECT clause.
WHERE
The text was updated successfully, but these errors were encountered:
WhereRaw? Can you not do it with that?
Sorry, something went wrong.
WhereRaw works on the overall query level, I am referring to the FILTER clause available on aggregate expressions. postgres docs
WhereRaw
Support added will be available in the next release
No branches or pull requests
In SQL we can add a
FILTER
clause to an aggregateSELECT
clause, i.e.It would be a huge help if SqlKata can support passing
WHERE
clauses with their bindings to aSELECT
clause.The text was updated successfully, but these errors were encountered: