Issue Parsing Semi-Colons when embedded in a string

[dm-duys]

Before Proceeding, please acknowledge:

• [x] I have consulted the Troubleshooting guide.
• [x] I have searched Issues and Discussions in this repo.
• [x] Feature requests should be initiated as Discussions. This is a bug report.

Describe the bug If you embed a ; as part of a string, Harlequin will see the content before it as a statement and attempt to execute.

To Reproduce Steps to reproduce the behavior.

1. Load up Azure Extension INSTALL azure; LOAD azure;

2. Attempt to create a secret.

CREATE PERSISTENT SECRET secret_sas_token(
   TYPE AZURE,
   CONNECTION_STRING 'BlobEndpoint=https://my.url.com;SharedAccessSignature=sv=....'
);

Expected behavior When parsing, it should exclude semi-colons if they are wrapped within a string literal

Actual behavior It seems to be parsing the content left of the content of any semi-colon. From above, it tries to execute:

CREATE PERSISTENT SECRET secret_sas_token(
   TYPE AZURE,
   CONNECTION_STRING 'BlobEndpoint=https://my.url.com

Contributing Are you interested in contributing a fix?

• [ ] Yes
• [ ] Maybe
• [x] No

Additional context Please provide as much as you can, but don't waste your time if it's definitely not relevant or you don't know.

What is the output of harlequin --version? 1.20.0

What database adapter are you using with Harlequin? (Default is duckdb) duckdb: 1.20.0

What other options are you using when invoking Harlequin? (If you are using a profile, please add relevant items from your profile here).

Can you tell us more about your system?

• Shell: bash 5.1.16
• Terminal: gnome
• OS of the shell: Ubuntu 22.04.4 LTX x86_64
• OS of the terminal (if different from the shell):
• Default locale / language for your OS/Terminal/Shell:

[!TIP] For example, for my system, these are:

• Bash
• Windows Terminal
• Ubuntu 22.04 / WSL2
• Windows 11
• en_US/UTF-8

How did you install Harlequin?

• [x] pipx
• [ ] conda/mamba
• [ ] pip (global install)
• [ ] pip + venv/virtualenv or pipenv
• [ ] Poetry
• [ ] uv/Rye
• [ ] other: _____

[tconbeer]

Yes, this is unfortunate. Duplicates https://github.com/tconbeer/harlequin/issues/348