Skip to content

Instantly share code, notes, and snippets.

@kidqueb

kidqueb/json-agg.ts

Last active March 13, 2024 15:41
Show Gist options
  • Save kidqueb/59d84b2280ff4e26d72206631e284e3e to your computer and use it in GitHub Desktop.
Save kidqueb/59d84b2280ff4e26d72206631e284e3e to your computer and use it in GitHub Desktop.
Download ZIP
json agg for drizzle
Raw
json-agg.ts
export function jsonAgg<T extends Record<string, AnyColumn>>(select: T) {
const chunks: SQL[] = [];
Object.entries(select).forEach(([key, column], index) => {
if (index > 0) chunks.push(sql`,`);
chunks.push(sql.raw(`'${key}',`), sql`${column}`);
});
return sql<InferColumnsDataTypes<T>[]>`
coalesce(
json_agg(json_build_object(${sql.fromList(chunks)})),
'[]'
)
`;
}
@Gardego5
Copy link

Thanks! I found this helpful!

Here's similar (but for sqlite) that infers with a Record<string, AnyColumn> or a Table
https://gist.github.com/Gardego5/b5e1bccdba5217f8507283b567b5605a

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment