Is there a way to build a query dinamically with the js client? For example, imagine we have a datatable and an input field to filter

sql
let query = supabase.from('users').select('name')

if (name) query = query.filter('name', 'LIKE' `%${name}%`)

Something like this should work:

js
if (name) {
  const query = supabase
    .from('users')
    .select('name')
    .filter('name', 'LIKE', `%${name}%`)
}

Yes, but thats not the point. The idea is to have a single query instance, and chain operators dinamically based on conditions. Another example where this would be useful

js
let query = supabase.from('table').select()

conditions.foreach((val, key) => query = query.eq(key, val)))

I haven't used supabase querying yet but I use knex and knex is like this, have you tried

js
const query = supabase.from('users');
const conditions = [ ['name', 'value here'] ];

for (const [key, value] of conditions) {
  query.filter(key, 'LIKE', `%${value}%`);
};

const res = await query.select('name');

@User so you have a supabase postgres database and use knex to query it?

no I was just saying supabase's query system is inspired by knex

@User can you try this? https://github.com/supabase/supabase/discussions/3080#discussioncomment-1282318

@soedirgo TYSM. That’s quite smart and what I was looking for. Cheers !