Error
I generally try to use Lava for retrieving data, but there are many times when SQL is just the best tool for the job. The problem is that I'm often not able to write the SQL in the most efficient way because I'm limited to a single result set per sql command. Instead I'm forced to either split it into multiple sql commands, or revert to using Lava as the second best tool for the particular job.
sql
I would love to see the ability to be able to return multiple result sets from a single sql command, much like how it works in the Dynamic Data block.
Cultivate your ideas for maximum impact with these helpful submission tips that will increase the chances of your brilliant concepts becoming reality.