this makes me think we shouldn't do it

That's a recommendation not to change the table structure. You're welcome to modify the JSON content of the metadata DB field. This has been the recommended way to add profile info directly for example, or store an ID to a related profile table entry.

We should change the docs to make it clear it's about the database schema.

https://github.com/nhost/nhost/pull/1316