As Many of them using Deephost Mysql extension , now it has stopped bcz of new kodular update
deephost extension had feature of getting list from response
so i prepared a guide to get list without his extension
i searched so much in community and most of them were using foreach block and it is not good for the app bcz if there are thousands of row then app may crash
here is the easy way to get it
First you all know how to call query , there are tutorial about it in community
previously select query used like this and this method gets as table
instead of using it , Use this method
"SELECT json_object(‘email’,email,‘name’,name,‘refer’,refer) FROM mytable; "
This method returns response as json
Next use this extension
This how you get Single List
Hope you understood my guide
hope this helped you