packages/twenty-server/src/engine/twenty-orm/utils/create-sql-where-tuple-in-clause.utils.ts

export const createSqlWhereTupleInClause = (
  conditions: [string, string][][],
  tableName: string,
) => {
  const fieldNames = conditions[0].map(([field, _]) => field);

  const tupleClause = fieldNames
    .map((field) => `"${tableName}"."${field}"`)
    .join(', ');
  const valuePlaceholders = conditions
    .map((_, index) => {
      const placeholders = fieldNames.map(
        (_, fieldIndex) => `:value${index}_${fieldIndex}`,
      );

      return `(${placeholders.join(', ')})`;
    })
    .join(', ');

  const clause = `(${tupleClause}) IN (${valuePlaceholders})`;

  const parameters: Record<string, string> = {};

  conditions.forEach((condition, conditionIndex) => {
    condition.forEach(([_, value], fieldIndex) => {
      parameters[`value${conditionIndex}_${fieldIndex}`] = value;
    });
  });

  return { clause, parameters };
};