SELECT Queries
How to execute SELECT Queries on Kwil Databases
On Kwil, there are two ways to read data from databases. The first way is to execute an action that contains a SELECT query. The second way is to pass a SELECT query to the .selectQuery() method on the kwil class.
To write a SELECT query, pass the DBID and the query as a string.
const res = await kwil.selectQuery("DBID", "SELECT * FROM table");
// res.data = [record1, record2, record3, etc]
Last modified 1mo ago