sqlValue
uses #tcm/host (encode)
What json_extract gives for a stored value: scalars as themselves (true as 1), anything else as its text.
import { isScalar } from "#codebase/tcmts/server"; import { encode } from "#tcm/host"; export const sqlValue = (v: unknown): string | number | null => (typeof v === "boolean" ? Number(v) : isScalar(v) ? v : encode(v)) as string | number | null