Same as #999 but for EF Core. @rwasef1830 you're welcome to do this whenever you want.

Note that there's the question of where the C# text functions should live (in EF6 it's NpgsqlTextFunctions), EF Core has an opinion on this - follow
dotnet/efcore#2850.