Function createSqlBuilder

packages/db/src/sql-builder.ts:17–94

()

}

export function createSqlBuilder() {
  const join = (obj: Record<string, string> | string[], joiner: string) =>
    Object.values(obj).filter(Boolean).join(joiner);

  const sb: SqlBuilderObject = {
    where: {},
    from: `${TABLE_NAMES.events} e`,
    select: {},
    groupBy: {},
    orderBy: {},
    having: {},
    joins: {},
    ctes: {},
    limit: undefined,
    offset: undefined,
    fill: undefined,
  };

  const getWhere = () =>
    Object.keys(sb.where).length ? `WHERE ${join(sb.where, ' AND ')}` : '';
  const getHaving = () =>
    Object.keys(sb.having).length ? `HAVING ${join(sb.having, ' AND ')}` : '';
  const getFrom = () => `FROM ${sb.from}`;
  const getSelect = () =>
    `SELECT ${Object.keys(sb.select).length ? join(sb.select, ', ') : '*'}`;
  const getGroupBy = () =>
    Object.keys(sb.groupBy).length ? `GROUP BY ${join(sb.groupBy, ', ')}` : '';
  const getOrderBy = () =>
    Object.keys(sb.orderBy).length ? `ORDER BY ${join(sb.orderBy, ', ')}` : '';
  const getLimit = () => (sb.limit ? `LIMIT ${sb.limit}` : '');
  const getOffset = () => (sb.offset ? `OFFSET ${sb.offset}` : '');
  const getJoins = () =>
    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,
    join,
    getWhere,
    getFrom,
    getSelect,
    getGroupBy,
    getOrderBy,
    getHaving,
    getJoins,
    getFill,
    getWith,
    with: (name: string, query: string) => {
      sb.ctes[name] = query;
    },