querydb

querydb(
    @sql ? ## symbol (required)
    @db null
) -> llll/null

Performs a SQLite3 query on previously created tables. See createdbtable.

---

Arguments

• @sql ? [symbol]: SQL table query. (required)
• @db [symbol/null]: Optional database name. If set to null, 'main' is used as the default database name. (default: null).

---

Output

query results. [llll/null]

---

Usage

## import MIDI events to use as data
$events = importmidi('bach.mid');
## create `notes` table based on MIDI events
createdbtable(@data $events @name 'notes');
## Use SQL query to retrieve all events with pitch class 0
$results = querydb('SELECT * FROM notes WHERE pitch % 1200 == 0');
print($results) ## print results