sql.indentIf(condition, fragment)

Conditionally adds indentation to SQL fragments based on a boolean condition. Useful for applying formatting only in certain environments or configurations.

ONLY indents when GRAPHILE_ENV is set to development or test.

See also: sql.indent(fragment)

Syntax

sql.indentIf(condition: boolean, fragment: SQL): SQL

Parameters

• condition - Boolean condition that determines whether to apply indentation
• fragment - The SQL fragment to potentially indent

Return value

Returns the fragment wrapped with indentation if condition is true, otherwise returns the fragment unchanged.

Example

import { sql, type SQL } from "pg-sql2";

function joinClause(conditions: SQL[]) {
  const sqlCondition = sql.join(
    conditions.map((fragment) => sql.parens(fragment)),
    " AND ",
  );
  return sql`on ${sql.parens(
    sql.indentIf(conditions.length > 1, sqlCondition),
  )}`;
}
console.log(sql.compile(joinClause([sql`age > 18`])).text);
/*
on (age > 18)
*/

console.log(
  sql.compile(joinClause([sql`age > 18`, sql`status = 'active'`])).text,
);
/*
on (
  (age > 18) AND (status = 'active')
)
*/