const statementUpdateSortOrder = sql.join(
    array.map((item, index) =>
        sql`WHEN id = ${item.id} THEN ${index}::integer`
    ),
    sql` `
);

await db.update(TableName)
    .set({ sort_order: sql`CASE ${statementUpdateSortOrder} END` })
    .where(inArray(TableName.id, array.map(item => item.id)));

const statementUpdateSortOrder = sql.join(
    array.map((item, index) =>
        sql`WHEN id = ${item.id} THEN ${index}::integer`
    ),
    sql` `
);

await db.update(TableName)
    .set({ sort_order: sql`CASE ${statementUpdateSortOrder} END` })
    .where(inArray(TableName.id, array.map(item => item.id)));