Database

Column is less than or equal to a value

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

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

Signature

builder.lte(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("products")
  .select("id, name, price")
  .lte("price", 9.99)
  .execute

supabase
  .from("readings")
  .select("*")
  .gte("recorded_at", "2026-06-01")
  .lte("recorded_at", "2026-06-30")
  .execute

Column is less than a value

Match rows where a column is less than a value.

Column matches a pattern

Case-sensitive pattern match using SQL LIKE.