Hello, in Corona to manage your database you have to write pure SQL and sometimes it is not good, also hard to mantain. I have created an API to ease this process, by offering an Object Relational Mapping (ORM) feature. It is free and open source. Feel free for suggestions:
https://github.com/lsoaresesilva/crate_orm
For example:
local aPerson = Person({age=30, surname="Soares"}) aPerson:save() -- saves an person in the database