RDBMS-specific functions in generic Database.Esqueleto module

[isomorpheme]

There's functions like ilike where the docs say:

Supported by PostgreSQL only.

Or others where both MySQL and Postgres support them, but no other RDBMSes. Then there's also modules like Database.Esqueleto.PostgreSQL that have RDBMS-specific code, and this is explicitly pointed out. So it seems like the intent is that such functions don't go in the generic Database.Esqueleto.

It's also pretty confusing as a user, and sometimes frustrating to find a function in HLS autocomplete that I can't actually use. It would be preferable if I can safely use anything from Database.Esqueleto (or of course .Experimental) without having to check individual docs if it's actually available on my RDBMS; anything that's implementation-specific should come from other modules.

[belevy]

True enough, though removing these functions from Database.Esqueleto is a breaking change.

[parsonsmatt]

I think we can do this in two parts: deprecation for 3.6 and removal in 4.0

[parsonsmatt]

I looked into this and I think only ilike needs to be deprecated. The other specific ones are either compatible with flags or new versions, or are already slated for deprecation (ie distinctOn #287 ): #412