Higher Order Extensions methods

[ahmad-moussawi]

A list of higher order functions that should be added to SqlKata. These features will be added as an extension project

• [ ] SelectCase, WhereCase, HavingCase, and GroupByCase support
• [ ] WithDateRange(DateTime from, DateTime to, string alias = "DateRange")
• [ ] WhereNullOrEmpty(col)
• [ ] WhereNullOrValue(col, 5) --> WHERE ([col] IS NULL OR [col] = 5)
• [ ] WithJson(string alias, string[] cols, string json), Read json array as CTE
• [ ] WithData(string alias, string cols, List<List<object>> data)

Please add your request in the comment section.

[johanndevilliers]

Hi @ahmad-moussawi

The Case support would be of great assistance. Do you have a timeline on when this will be completed?

PS. Loving SQLKata

Regards

[ghost]

Is there an update here with the Case statements?