Help Wanted. Database query builder

[sjwalker189]

Heya, Is there the ability to use both models and a query builder? I cannot find anything in the docs

i.e. something like this would be perfect

const store = new Store({
  file: 'path/to/db.sqlite'
})

store.ready(async () => {
   const user = await store.table('users').where('id', 1).get()
})

Cheers

[PhilWaldmann]

openrecord uses knex for all SQL stores. To get your example working, you'll need to access the store.connection.

const store = new Store({
  file: 'path/to/db.sqlite'
})

store.ready(async () => {
   const user = await store.connection.table('users').where('id', 1).get()
})

[sjwalker189]

Awesome, thanks for the help!