Function buildRowOrderBySql

apps/sim/lib/table/rows/service.ts:745–760

* Canonical ORDER BY for a table's rows, shared by `queryRows` (the paginated * list) and `findRowMatches` so a match's ordinal lines up with its index in * the list. Order: explicit data sort (if any) → fractional `order_key` or * legacy `position` → `id`. The `id` tiebreak is always appended so

(
  sort: Sort | undefined,
  tableName: string,
  columns: ColumnDefinition[],
  fractionalOrderingEnabled: boolean
)

 * (a find vs a list page) could shuffle ties and misalign ordinals.
 */
function buildRowOrderBySql(
  sort: Sort | undefined,
  tableName: string,
  columns: ColumnDefinition[],
  fractionalOrderingEnabled: boolean
): SQL {
  const primary = fractionalOrderingEnabled ? `${tableName}.order_key` : `${tableName}.position`
  const id = `${tableName}.id`
  if (sort && Object.keys(sort).length > 0) {
    const sortClause = buildSortClause(sort, tableName, columns)
    if (sortClause) {
      return sql.join([sortClause, sql.raw(primary), sql.raw(id)], sql.raw(', '))
    }
  }
  return sql.raw(`${primary}, ${id}`)
}

/** One matching cell from {@link findRowMatches}. */
export interface FindRowMatch {