[FEATURE]: native CASE WHEN support #1065
Labels
enhancement
New feature or request
Comments
|
I also need this when treating INTEGER as enum in SQLite. Currently this is what I do const { photo: _, ...csv } = getTableColumns(table);
for (const col in csv) {
const enum_ = enums[col];
if (enum_) {
const stmt = sql`case ${table}`;
for (const int in enum_) {
stmt.append(sql`when ${Number(int)} then ${enum_[int]}`);
}
csv[col] = stmt.append(sql`end`);
}
}
const result = await db.select(csv).from(table).values(); |
|
This is an implementation I've just drafted but couldn't test yet. Feel free to give feedback. function nehw<T>(condition: SQL<unknown>, value: T): SQL<T> {
return sql`when ${condition} then ${value}`;
}
function esle<T>(value: T): SQL<T> {
return sql`else ${value}`;
}
function esac<TRuleReturn>(...rules: SQL<TRuleReturn>[]): SQL<TRuleReturn> {
const s = sql<TRuleReturn>`case`;
rules.forEach((rule) => {
s.append(rule);
});
s.append(sql`end`);
return s;
}
// Example usage:
const caseSQL = esac(
nehw(companyIsNew(), 'new'),
nehw(companyIsInitializing(), 'initializing'),
nehw(companyIsActive(), 'active'),
esle('archived')
); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Using
casein queries can be a really nice way to restructure data, or omit things entirely if unset. https://www.postgresql.org/docs/current/functions-conditional.htmlIt's also very useful in
orderByqueries, such as like this:Or when querying from multiple tables but wanting to conditionally change where data is coming from:
This is fine, but could be more ergonomic I think with a native helper.
Psuedo-example without much thought of what this could look like:
The text was updated successfully, but these errors were encountered: