A bit tangential, but I hate that products like DrawSQL only have a subscription models. It seems interesting, and would like to use it but why should I pay for a subscription? What if I only need it for 1 project? Why should I keep paying every month when I will rarely be touching the model every now and then? I understand that software is expensive to build, maintain and grow, but I just can't seem to tolerate subscription models for every single product. There are some products/services that make sense to charge like that but nowadays everything seems to be like that.
Such apps are not targeted towards occasional user like you. These products are more targets towards people who need to constantly work with schemas , architects/ consultants etc . Perhaps they are more likely to pay in the first place . As you say it is hard to pay if you need it rarely .
perhaps tools like datagrip make more sense for you ? Especially if you already are in jetbrains ecosystem (although they have annual pricing as well, if you don’t renew you get last version your subscription covered Perpetually )
LibreOffice Base has the exact same feature, FWIW. You can access it by opening the Tools -> Relationships window. It's nothing special, even Access used to do this just fine.
