NeonCop Comments - Answer Overflow

seeing this too, even when I have the column in date mode, I get a typescript error if i have it as a iso string, and a runtime error if i leave it as a date. The between fix doesn't even work for me 😦

9 replies

DTDrizzle Team

•Created by francis on 9/4/2023 in #help

Drizzle join in a subquery results in ambiguous columns

my use case here is joining tables a and b which both have id field, and flatten the results in one table but not the other (so result is something like {id, field1FromA, field2fromA, b: {id, field1fromB}}). if i just execute that query, it correctly creates an object with that shape. But if I create a subquery called c, and then try to use c in a join (using c.id i.e. a.id), then it says ambiguous column because the underlying select selects it twice. This is probably some sort of nice runtime magic to nest objects but ends up messing up the sql downstream.

26 replies

DTDrizzle Team

•Created by francis on 9/4/2023 in #help

Drizzle join in a subquery results in ambiguous columns

+ 1

26 replies

DTDrizzle Team

•Created by JT on 2/11/2024 in #help

where has iterator gone?

any idea where this went? looking for a snippet foir a utils function for postgres that can help me use a generator for results even if it's just doing ab unch of queries in the back

5 replies

DTDrizzle Team

•Created by JT on 4/9/2023 in #help

Iterator for result set

any idea how to do this in postgres? can't quite seem to get the types right on thsi util function

10 replies

DTDrizzle Team

•Created by anthonyshew on 5/4/2023 in #help

Trying to write next-auth adapter

this is awesome work!!

81 replies

DTDrizzle Team

•Created by NeonCop on 3/28/2023 in #help

uuid's being inferred as strings

hmmm so the right way to do it would be to use something like zod to validate / generate the typescript types? guessing this will make sense once Select schema goes live

4 replies

Gaming

Programming