D McMurchy

First off - thank you very much for putting this together as I've found it very useful and informative on my SQL data analyst journey. From: http://www.windowfunctions.com/questions/over/3 The question states...

Page URL: The documentation under UNION states: ` The UNION clause can be used to combine rows from multiple queries. The queries are required to have the same number of...

ValueError: No closing quotation / Likely argument parsing issue.

3

### What happens? Executing: ```shell %sql SELECT TRIM(' padded '); ``` Produces a ValueError: ```shell ----> 1 get_ipython().run_line_magic('sql', "SELECT TRIM(' padded ');") File ~\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.11_qbz5n2kfra8p0\LocalCache\local-packages\Python311\site-packages\IPython\core\interactiveshell.py:2432, in InteractiveShell.run_line_magic(self, magic_name, line, _stack_depth) 2430...

Issue on page /integrations/duckdb.html

4

Would be helpful to include instructions for connecting to a persistent duckdb database. The create _engine option works but has some caveats with respect to the path. Under Windows if...

The section [Querying Pandas DataFrames](https://duckdb.org/docs/guides/python/jupyter#querying-pandas-dataframes) should be updated to mention that in order for DuckDB >= 1.1.0 to query a dataframe the following must be run first[^1]. ```python SET python_scan_all_frames...