Support for `distinct` in functions and the `BETWEEN` WHERE-clause construct

Zaid-Ajaj / Npgsql.FSharp.Analyzer

F# analyzer that provides embedded SQL syntax analysis, type-checking for parameters and result sets and nullable column detection when writing queries using Npgsql.FSharp.

MIT License

137 stars 9 forks source link

Dear @Zaid-Ajaj, thank you for all the wonderful work you are doing for the open-source community!

I am considering using the SQL parser part of your library in a reference implementation I am building. Currently, it is missing two features I would rely on, namely:

the ability to use the distinct keyword in a function (such as count(distinct column), and
the BETWEEN keyword for WHERE-clauses (WHERE age BETWEEN 1 and 20)

Would you welcome pull-requests to add these features?

If yes, are there any particular things I should keep in mind while adding these features? Say some non-obvious aspect of your library that doesn't immediately spring to mind but needs to be considered?

Zaid-Ajaj / Npgsql.FSharp.Analyzer

Support for `distinct` in functions and the `BETWEEN` WHERE-clause construct #23