Fetch data: select()

Perform a SELECT query on a table or view.

By default, Basalt returns at most 1,000 rows. Change the limit in your project's API settings, or page through results with range().

const { data, error } = await basalt
  .from('characters')
  .select()

const { data, error } = await basalt
  .from('characters')
  .select('name, house')

{
  "data": [
    { "id": 1, "name": "Ada" },
    { "id": 2, "name": "Grace" }
  ],
  "status": 200
}