Clancy Gilroy
DTDrizzle Team
•Created by Clancy Gilroy on 5/2/2024 in #help
MySql 5.7
Hello! I've been trying to get this going for a few days now. I've been trying to query data with relationships in mysql 5.7 using drizzle.
What I know so far using mysql2 driver.
- Normal mode doesn't work because lateral joins are not supported in mysql 5.7.
- Planetscale mode doesn't work because fields are used in subqueries before they're in scope.
I've tried downgrading to
drizzle-orm 0.27 but then when querying the table with one relationship the script hangs indefinitely
I have searched all of google and the docs with no answer so far.
Anyone has any idea? :D, thank you very much in advance.1 replies