Add Oracle Synonyms to explorer sidebar

[flacrosse]

What

Show Oracle synonyms in the database explorer sidebar tree and include them in autocomplete/IntelliSense suggestions.

Both private synonyms (owned by the current user) and public synonyms, ideally under a "Synonyms" node within each schema — similar to how tables and views are grouped today.

Why (problem/use case)

Synonyms are a first-class object type in Oracle and are used heavily in production schemas — particularly public synonyms that alias objects across schemas or point to remote database links. When synonyms aren't visible in the tree:

• You can't tell at a glance which synonym names are available without running SELECT * FROM all_synonyms manually.
• Autocomplete doesn't suggest synonym names, so queries that rely on them have to be typed from memory.
• It's impossible to inspect a synonym's target (owner, table/view name, DB link) without dropping to SQL.

Additional Context

Oracle exposes synonyms via ALL_SYNONYMS (accessible synonyms) and USER_SYNONYMS (owned by current user).

SELECT owner, synonym_name, table_owner, table_name, db_link
FROM all_synonyms
ORDER BY owner, synonym_name;

[mikeburgh]

I just released 1.36.11 which includes a first pass at support for synonyms.

One thing to note, they are only there for progress loading.. so you will need to edit the conneciton, and enable that option in Advanced.

I still need to add more features like opening them if they are tables, scripting, rename, drop etc.. but they should be showing in the tree now and working correctly in autocomplete and hover.

Also, there is an issue publishing to the marketplace at the moment, so if you are using VSCode, it might take a while to show up, but you can get the latest one from the Github releases section https://github.com/dbcodeio/public/releases/tag/v1.36.11

[flacrosse]

This is great and so quickly implemented! Just having this visibility alone is a game changer for me at work. Thanks!