Double Quoted Identifier

[TTUEagle]

It would be great if the extension supported automatically double-quoting object names when using drag & drop from the Connections explorer on the left-hand side to a script on the right-hand side. DBeaver does this very well.

[mmcfarland]

Hi @TTUEagle , thanks for the request. To clarify, you'd prefer if the dragged object name came over to the editor window as, e.g., "humanresources"."department" instead of humanresources.department? I think this would be a nice improvement.

[TTUEagle]

@mmcfarland, that is correct. When I drag an object over to the script, it'd be great if the name came over as, for example, public."UserOrder" instead of public.UserOrder, which throws a syntax error due to case-sensitivity.

[mmcfarland]

Hi @TTUEagle we've released an enhancement in pre-release version 1.9 that should resolve this issue. It will be available if you opt-in to the pre-release version channel for this extension in VS Code. The fix should roll out to all users in stable-release 1.10 in about a week. Please let us know if this resolves your issue. See the full changelog here.

[TTUEagle]

Wonderful news! I look forward to the new functionality. Thank you!

[mmcfarland]

Fixed in v1.10