Function getWith

packages/db/src/sql-builder.ts:51–58

()

    Object.keys(sb.joins).length ? join(sb.joins, ' ') : '';
  const getFill = () => (sb.fill ? `WITH FILL ${sb.fill}` : '');
  const getWith = () => {
    const cteEntries = Object.entries(sb.ctes);
    if (cteEntries.length === 0) return '';
    const cteClauses = cteEntries.map(
      ([name, query]) => `${name} AS (${query})`,
    );
    return `WITH ${cteClauses.join(', ')} `;
  };

  return {
    sb,