Rezoom.SQL

> A type provider that allows local schema would deal with your issue and then you would get type checked SQL queries at compile time without the direct db dependency and connection latency. You might be interested in Rezoom.SQL [1], which is exactly the thing you describe. As an aside, it also has unusually thorough documentation [2] by F# standards. [1] https://github.com/rspeele/Rezoom.SQL [2] https://rspeele.gitbooks.io/rezoom-sql/doc/Tutorial/

There's a new type provider out that takes a different approach by bundling a SQL parser: https://github.com/rspeele/Rezoom.SQL It can't check everything that the other providers can, but IMO you get most of the benefit without requiring any onerous build-time dependencies.

The necessary bits are there in .NET for F#; possibly also C# 7: https://news.ycombinator.com/item?id=14896809 This all could make it very easy to write a GraphQL server backed by Rezoom + Rezoom.SQL. https://github.com/rspeele/Rezoom https://github.com/rspeele/Rezoom.SQL -- If there are any other resources I'm not aware of, please let me know!