I'm developing a database-hungry app/game. Coming from a web/sql background, I thought that I could easily add the usual sql syntax and the logic using the sqlite3 library.

Since there isn't much documentation on corona (only an example to create a table and to show n amount of records from a select), I used http://www.nessie.de/mroth/lua-sqlite3/documentation.html as reference.

But I noticed that for example, if I want to use any of the one-row fetching options (http://www.nessie.de/mroth/lua-sqlite3/documentation.html#ref8) I keep getting errors in the terminal - attempt to call method XXXXXXX (a nil value)

I don't want to use the nrows option to get only 1 record (especially if is it as simple as "select count(whatever.ID) from whatever").

Is it possible to know what Corona does support regarding sqlite? Or am I missing something?

Thanks!

Yeah, you must be missing something....Corona's support for sqlite is not as complete as raw C, but all of the above access methods work for me. Just make sure you code to report any sqlite errors as it can get confusing as to which/where your database file resides and I experienced similar frustration with "table does not exist" errors when I had accidentally opened an empty DB.