Skip to content

Fields

The field parameter can receive a string of a list of strings, you can use this to leverage your python code to don't have to join the string together

Selecting with a string

const qb = new D1QB(env.DB)

const fetched = await qb
  .fetchAll({
    tableName: 'employees',
    fields: '*',
  })
  .execute()
const qb = new D1QB(env.DB)

const fetched = await qb
  .fetchAll({
    tableName: 'employees',
    fields: 'name, birth_date',
  })
  .execute()

Selecting with a list of strings

fields = ['name', 'birth_date']

// Include more fields on some conditions
if (includeDepartments) {
  fields.push('department')
}

const qb = new D1QB(env.DB)

const fetched = await qb
  .fetchAll({
    tableName: 'employees',
    fields: fields,
  })
  .execute()