Hello,
I have the Personal Version of SQLite, which does not have the visual tool to build queries.
It is quite boring to build and test my queries.
Is there a tool or app (free) to create them?
have you tried to pass the sql create of your database to an AI, and ask it something like: "I need all the records from that table that meet this condition, but no... bla bla bla"
have you tried to pass the sql create of your database to an AI, and ask it something like: "I need all the records from that table that meet this condition, but no... bla bla bla"
As I don't use SQLite (or any other SQL) all the time and am no database expert, it's always a bit of a challenge to get the SELECT syntax right, specifically when relationships between tables (JOINs) come into play. There's that, and the fact that it was fun to develop (and I wanted to have the...