Return a database from a query
I use SQL in many projects, and that is often in the form of SQLite. Something of a limitation I find is that only a single table can be returned from a single query. Whilst using SQLite, that’s often not so much of an issue since making several queries is less of a performance issue when it does not involve multiple round trips to a server. Nonetheless it can sometimes either mean extra computation, or doing more in the general purpose language to post-process the results of a single query. In addition, to sometimes the wastefulness of repeating the same answer. Anyway, I think this is best shown with an example in mind. ...