So as far as I can figure out, this has something to do with the sql_mode being set to only_full_group_by. I'm using planetscale and it literally only happens on my development branch.. If I connect to my main branch it works fine. 🙄