Remove support for backends that do not support foreign keys

Support for backends without foreign key support has been introduced in the ancient days when SQLite did not still support them. Now that SQLite supports foreign keys (it does since 2009) and Akonadi makes use of them (since 2018), there's no longer need to have checks for foreign key support and fallback code paths for cases when FKs are not supported.