Tibfib
DTDrizzle Team
•Created by kajl_pl on 7/15/2024 in #help
Self referencing table query
I think I'll just do a manual with recursive query with
sql to get the ids, then use the query api to get the actual items. I think my size will permit it. Then I'll swap out with a single recursive query when it's ready43 replies
DTDrizzle Team
•Created by kajl_pl on 7/15/2024 in #help
Self referencing table query
@Raphaël M (@rphlmr) ⚡ Wow, this is great and very helpful for the camelCase issue!
Unfortunately, there's just too much I'm losing with the "raw" to work around beyond just the camelCase issues. I've got custom types not running, I've got a
bigserial +bigint columns coming in as strings, etc. Is there a way to manually convert each record using a table's columns definition? That would be a great stopgap solution until $withRecursive comes out43 replies
DTDrizzle Team
•Created by kajl_pl on 7/15/2024 in #help
Self referencing table query
dang, and I'm assuming there's no easy workarounds?
43 replies
DTDrizzle Team
•Created by kajl_pl on 7/15/2024 in #help
Self referencing table query
if I add another column to the schema and try to reference it, it comes down in snake case https://drizzle.run/v7feo604avcvkfr5jz65km3u
43 replies
DTDrizzle Team
•Created by kajl_pl on 7/15/2024 in #help
Self referencing table query
and I think same issue, but it's also not running my custom column type processing
43 replies
