Remix.run Logo
SophieBroderick 5 days ago

I've been working on an new approach to working with SQL: https://5QL.site

You select columns and then just drill down to create further joins. Change the SQL text and it updates the view.

I'm a CS undergrad would love feedback.

iambateman 5 days ago | parent [-]

This is interesting, both in the sense that you did a great job on it, and I think unexpected-ways-to-explore-SQL is underrated. There are a lot of SQL databases that people could benefit from being able to drop a tool like this onto and explore.

One of the most interesting applications for LLM's is writing SQL based on a schema, and I wonder if your tool could incorporate a "show me the books titles from authors who's name starts with T" and write that out.

Good luck!

SophieBroderick 5 days ago | parent [-]

Thank you!

Yes, I agree. Just as we need to check what LLMs produce when writing code, I think this could be a way to check what they produce when trying to write SQL.