(This is a personal clone of http://code.google.com/p/luadbi/w/list)

DBI.Do(dbh, "DELETE FROM tab WHERE id < ?", 100)

LuaDBI is a database interface library for Lua. It is designed to provide a RDBMS agnostic API for handling database operations. LuaDBI also provides support for prepared statement handles, placeholders and bind parameters for all database operations.

Currently LuaDBI supports DB2, Oracle, MySQL, PostgreSQL and SQLite databases with native database drivers.

See https://github.com/nopdotcom/luadbi/tree/wiki and https://github.com/nopdotcom/luadbi/blob/wiki/DBI.md .