I went ahead and worked up a short blog post about this: http://xylil.com/2020/07/01/freeswitch-dbh-fetch-convenience-functions-for-lua/

On Mon, Jun 15, 2020 at 9:07 PM Chad Phillips <chad@apartmentlines.com> wrote:
Curious if https://freeswitch.org/confluence/display/FREESWITCH/Lua+with+Database#LuawithDatabase-freeswitch.Dbh is missing any support functions that freeswitch.Dbh has under the hood?

It seems some convenience functions for the following would be quite nice:

 - Fetch query results into a table of tables
 - Fetch one result row
 - Fetch one row

I hacked up those in some quick helpers here: https://gist.github.com/thehunmonkgroup/f92ca495c4c366d74fa9269320806cec

Just wondering if I'm missing anything.