Allow Returning Multiple Results from SQL Lava Command

Allow Returning Multiple Results from SQL Lava Command


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.

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.

Photo of Jeff RichmondSubmitted by Jeff Richmond, The Well Community Church  ·   ·  Lava
Login to add a comment...

Submission Success Tips

Cultivate your ideas for maximum impact with these helpful submission tips that will increase the chances of your brilliant concepts becoming reality.

  • Clear Title: Craft a straightforward and descriptive title that instantly conveys the essence of your idea.
  • Concise Description: Provide an idea description that is succinct, ensuring it effectively communicates the concept without unnecessary verbosity.
  • Provide Additional Details: With a concise description complete, now provide any other details that are needed to better understand the requirements.
  • Thorough Ministry Need Review: Provide a comprehensive overview of the ministry need your idea addresses, emphasizing its significance.
  • Cover the WHY: Clearly articulate the rationale behind your idea, explaining why it's essential and how it aligns with the organization's goals and mission. Oftentimes a clear "why" sheds light into other possible options.