Functions for SQL

The box module contains some functions related to SQL:

box.schema.func.create – for making Lua functions callable from SQL statements. See Calling Lua routines from SQL in the SQL Plus Lua section.
box.execute – for making SQL statements callable from Lua functions. See the SQL user guide.
box.prepare and box.unprepare.

Some SQL statements are illustrated in the SQL tutorial.

Below is a list of all SQL functions and members.

Name	Use
box.execute()	Make Lua functions callable from SQL statements. See Calling Lua routines from SQL in the SQL Plus Lua section
box.prepare()	Make SQL statements callable from Lua functions. See the SQL user guide
object prepared_table	Methods for prepared SQL statement

Name

Use

Make Lua functions callable from SQL statements. See Calling Lua routines from SQL in the SQL Plus Lua section

Make SQL statements callable from Lua functions. See the SQL user guide

Methods for prepared SQL statement