const condition = dirPaths
.map((dir) => sql`${sql.identifier(['file_path'])} LIKE ${dir + '%'} COLLATE NOCASE`)
.reduce((acc, condition) => sql`${acc} OR ${condition}`);
db.selectFrom(tableName).selectAll().where(condition).execute();
const condition = dirPaths
.map((dir) => sql`${sql.identifier(['file_path'])} LIKE ${dir + '%'} COLLATE NOCASE`)
.reduce((acc, condition) => sql`${acc} OR ${condition}`);
db.selectFrom(tableName).selectAll().where(condition).execute();