On last week’s livestream we demo’d a powerful SQL query building library we are developing. It’s type safe, composable, constructs valid SQL and leverages some of Swift's most powerful features, such as key paths, macros and variadic generics.

We will have a lot more to share about the library soon, but for now get a sneak peek from the recording of our livestream:

Automated GitHub, GitLab, Bitbucket and Jira backups, security compliance, data migration and every-scenario-ready Disaster Recovery for 360 cyber resilience. Schedule a custom demo or try 14 days for free.

Love this, I have a macro based typesafe query dsl as well that I’ve been using for a while. I would gladly stop building it in favour of a pointfree version 😂

Let us know if you want to compare notes sometime!

Don’t know what I think about this. Very impressive but it feels very much like the Swift HTML DSLs everyone was making a few years ago. SQL is powerful because it’s concisely expresses complex scenarios using just a string.

The DSL tries to stay as true to SQL as possible but also provides an escape hatch for writing raw SQL anywhere in a query: .where { $0.date > .raw("datetime('now' , '-7 days')") } Can you explain your comment about HTML DSLs? Not sure we see the relevance here.

How do you make it to display and update in a preview? Simply #Preview { Text(query.sqlString) }? That’s a neat trick

Yep that’s it! 🙂