Function applyConditionToQuery

src/services/sql.ts:134–145

(query: knexlib.Knex.QueryBuilder, conditions: WhereEntry[])

}

function applyConditionToQuery(query: knexlib.Knex.QueryBuilder, conditions: WhereEntry[]): knexlib.Knex.QueryBuilder {
	for (const clause of conditions) {
		if (clause.useRawCast) {
			// Use raw to cast the column to text for the comparison
			query = query.whereRaw(`${clause.column}::text ${clause.operator} ?`, [clause.value]);
		} else {
			query = query.where(clause.column, clause.operator, clause.value);
		}
	}

	return query;
}

function getTransformedValue(targetColumn: Column, value: any, isNumericComparison: boolean) {
	if (targetColumn.type === 'boolean') {