Function reconstructTableQuery

src/utils/editor.ts:326–363

(
  tab: Tab,
  driver?: string,
  options?: ReconstructQueryOptions,
)

 * instead of appending directly.
 */
export function reconstructTableQuery(
  tab: Tab,
  driver?: string,
  options?: ReconstructQueryOptions,
): string {
  if (!tab.activeTable) {
    return tab.query;
  }

  const filterClause =
    options?.filterOverride !== undefined
      ? options.filterOverride
      : tab.filterClause;
  const sortClause =
    options?.sortOverride !== undefined
      ? options.sortOverride
      : tab.sortClause;
  const limitClause =
    options?.limitOverride !== undefined
      ? options.limitOverride
      : tab.limitClause;

  const filter = filterClause ? `WHERE ${filterClause}` : "";
  const sort = sortClause ? `ORDER BY ${sortClause}` : "";
  const quotedTable = quoteTableRef(tab.activeTable, driver, tab.schema);

  let baseQuery = `SELECT * FROM ${quotedTable} ${filter} ${sort}`.trim();

  if (limitClause && limitClause > 0) {
    if (options?.wrapLimitSubquery) {
      baseQuery = `SELECT * FROM (${baseQuery} LIMIT ${limitClause}) AS limited_subset`;
    } else {
      baseQuery = `${baseQuery} LIMIT ${limitClause}`;
    }
  }

  return baseQuery.replace(/\s+/g, " ").trim();
}

/**
 * Format an export filename with timestamp and extension