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.