Finds all rows whose value in the stated column
matches the supplied pattern
(case insensitive).
supabase.postgrest["cities"].select(columns = Columns.list("name")) {
City::name ilike "%la%"
//or
ilike("name", "%la%")
}
val toUpdate = City(name = "Mordor")
supabase.postgrest["cities"].update(toUpdate) {
City::name ilike "%la%"
//or
ilike("name", "%la%")
}
supabase.postgrest["cities"].delete {
City::name ilike "%la%"
//or
ilike("name", "%la%")
}
supabase.postgrest.rpc("echo_all_cities") {
City::name ilike "%la%"
//or
ilike("name", "%la%")
}