ENH: Load SQL engine backends via `entrypoints`
Follow up to #36893. Per @xhochy's suggestion we should use `entrypoints` as a mechanism for loading alternate SQL engine backends, similar to what we do with plotting backends. Creating a new issue for it per the comment [here](https://github.com/pandas-dev/pandas/pull/40556#discussion_r625243915).