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]