© 2026 Hedgehog Software, LLC
const res = await ctx.database .select() .from(worker) .where( and( eq(worker.locationUid, input.location), isNull(worker.deletedAt), ilike(worker.name, "%{input.name}%") ) )
input.name
null
[..., input.name && ilike(worker.name, "%{input.name}%) : null].filter(v => v)