Database

Column is less than a value

Match rows where a column is less than a value.

Filter rows where column < value. Chains onto any verb builder.

Signature

builder.lt(column, value)

Name	Type	Required	Description
`column`	String / Symbol	Required	Column name.
`value`	Any	Required	Value to compare against.

self (FilterRequestBuilder)

The same builder for chaining.

supabase
  .from("countries")
  .select("name, population")
  .lt("population", 1_000_000)
  .execute

supabase
  .from("invoices")
  .select("*")
  .gte("issued_at", "2026-01-01")
  .lt("issued_at", "2026-02-01")
  .execute

Column is greater than or equal to a value

Match rows where a column is greater than or equal to a value.

Column is less than or equal to a value

Match rows where a column is less than or equal to a value.