[GEOT-4486] JDBCDataStore allow synonyms

This is the pull request on 9.x for the synonym issue GEOT-4486. (I just did a cherry-pick but I think on this way it is more comfortable for you to backport such changes. If not, just let me know and I won't create pull requests twice.)