Add the abillity to select type of relation field in many to any relation

Summary When creating a Many To Any relation you can select the type of the relation field string(default), integer. Basic Example _No response_ Motivation When you create a many to any relation field the relation(item) field is always a string. When you run the query it needs to CAST the target tables id to CHAR(255). Which is a slow database operation. We have a query with m2a from 1 collection to 3 other collections. The query takes 6 seconds to complete. We changed the type in the relations table to integer and it took 100-200ms Detailed Design Somewhere in the schema we need to define the type of the relation field to determine when to use CAST or not. Requirements List Must Have: • Must be able to select database string or integer type for new m2a relations Drawbacks • When u use the integer type for relation you can't add all the collections as m2a only collections with integer as ID. Alternatives The impact would be slow database performance abou…