I imagine it is probably too late to change the way the sql databases are constructed with relationships and the tables it creates. However, the problem I’m having is that before when I had relationships just in a column on a table. i.e user would have a column with a foreign key column of house_id. Now Prisma creates a new table and a new row, therefore there are 2 rows for every relationship. This becomes a cost problem with services like AWS or Heroku databases where they charge per row.
This is more a concern with the general product itself and is a bit concerning tbh. Has there been any discussion around this?