Execute (/database/query proc)

Runs the generated query against the provided database. If the query is expected to return data, you can increment the row being read with /database/query /proc/NextRow().

var/database/db = new("mydb.db")
var/database/query/query = new("SELECT user FROM leaderboard ORDER BY score ASC")
query.Execute(db)

var/list/top_scorers = list()

while(query.NextRow())
    top_scorers += query.GetColumn(0)

Parity Issue ⚠️

In the OpenDream implementation of DreamMaker, this feature differs in implementation:

We do not currently support running Execute() without a database datum provided. The BYOND implementation of DreamMaker supports passing a filename.