Function countRowsTenantBounded

apps/sim/lib/table/rows/service.ts:944–949

* `COUNT(*)` for a filtered view, kept inside the tenant's rows: measured * 12.7s → 1.0s counting a rare ILIKE filter on a 1M-row table inside a 12M-row * relation (see withSeqscanOff for why the planner gets this wrong).

(whereClause: SQL | undefined)

 * relation (see {@link withSeqscanOff} for why the planner gets this wrong).
 */
async function countRowsTenantBounded(whereClause: SQL | undefined): Promise<number> {
  return withSeqscanOff(async (trx) => {
    const [result] = await trx.select({ count: count() }).from(userTableRows).where(whereClause)
    return Number(result.count)
  })
}

export async function queryRows(
  table: TableDefinition,