@davedelong It's not out yet, but the upcoming StructuredQueries library from @pointfreeco might be what you're looking for? They start showing how they've built it in a video series (linked below), but the gist is that you annotate your model object with an `@Table` macro, and then you can do something like `Contact.where { $0.firstName == "John" }` and call `queryFragment` on it to get the generated SQL statement for it.

Or is that doing more than you want and you're looking for something that would provide a `SQLStatementLiteral` type that would let you do a string literal for the SQL statement, substitute values in with string interpolation, and properly escape them?

https://www.pointfree.co/episodes/ep314-sql-builders-sneak-peek-part-1

@davedelong @grantjbutler Good luck. I am very curious how dynamic your schema really needs to be. A heavily dynamic db schema sounds terrifying to me.

In any case Swift generics have gotten SO much better in the last few years. I think it might be able to handle your dynamism better than you might realize.

@davedelong @dandylyons @grantjbutler We're not sure it'll be what you're looking for, but the library is live as of this morning: https://github.com/pointfreeco/swift-structured-queries

It's a general purpose type-safe SQL builder that an ORM could certainly use, so if you do end up kicking the tires, please let us know what you think and if we can help in any way!

@pointfreeco @dandylyons @grantjbutler Here's what I'm trying to do: https://mastodon.social/@davedelong/114371921912511612

and yesterday I worked through the syntax diagrams to define them as structs and enums: https://github.com/davedelong/sqlsyntax