Fix parsing sql query.py

[Thomas-AH-Heller]

Description

Sometime the parsing was not working properly for the sql query engine. LLM sometimes started the answer with SQLQuery:, or used markdown, it would even comment between the end of the sql query and the final result.
This was test with mistral AI, Open AI, llama 2/3 and wizard LM. It improved the parsing for all of them, leading to no new bug detected due to the new parsing.

Fixes # (issue)

New Package?

Type of Change

Please delete options that are not relevant.

• Bug fix (non-breaking change which fixes an issue)
• New feature (non-breaking change which adds functionality)
• Breaking change (fix or feature that would cause existing functionality to not work as expected)
• This change requires a documentation update

How Has This Been Tested?

Please describe the tests that you ran to verify your changes. Provide instructions so we can reproduce. Please also list any relevant details for your test configuration

• Added new unit/integration tests
• Added new notebook (that tests end-to-end)
• I stared at the code and made sure it makes sense

Suggested Checklist:

• I have performed a self-review of my own code
• I have commented my code, particularly in hard-to-understand areas
• I have made corresponding changes to the documentation
• I have added Google Colab support for the newly added notebooks.
• My changes generate no new warnings
• I have added tests that prove my fix is effective or that my feature works
• New and existing unit tests pass locally with my changes
• I ran make format; make lint to appease the lint gods

[nerdai]

Thanks @Thomas-AH-Heller. Would it be possible to add a unit tests for each of the conditions that you're checking for?

[Thomas-AH-Heller]

Thanks @Thomas-AH-Heller. Would it be possible to add a unit tests for each of the conditions that you're checking for?

@nerdai Done !

[nerdai]

Thanks @Thomas-AH-Heller for the fix and adding the unit tests -- much appreciated!