Auto index foreign key

[vani-rf]

Problem

I'm facing performance issues in Supabase, where foreign keys are not automatically indexed. This causes some queries to be inefficient, particularly when working with large datasets. Supabase's performance editor highlights this as a key optimization concern, and I have to manually create indexes for foreign keys, which is not ideal for scalability or developer experience.

Solution

I would like Raiden to automatically create indexes on foreign key columns when models are applied to Supabase. This feature should ensure that whenever a foreign key is added, the corresponding index is automatically generated, improving query performance without manual intervention.

[toopay]

Also add the foreign key options (both in cloud and local drivers) for on delete/on update.

[toopay]

@vani-rf It seems the feature is able to generate the model, but after updating the tag, it still tries to generate the same tag (see screenshot). It looks like this needs to be revisited, especially the part that compares the differences—because there is no difference here, yet it keeps showing as if there is.