I want to move from postgres to mysql so our team can use planetscale. Since scalar lists arent supported in mysql, whats the best way of handling moving a postgres db with scalar lists to mysql?

Hey Damian 👋 As MySQL doesn’t support scalar lists people usually prefer to store arrays in JSON as described in this blog post

Another option would be to use foreign keys like this: https://www.prisma.io/docs/guides/general-guides/database-workflows/foreign-keys/mysql