D McMurchy

Thanks for commenting about CSV Lint! I had updated it recently and then noticed the background highlighting issue happening and was driving me a little crazy. Note to anyone else...

Data is from [here](https://duckdb.org/docs/sql/statements/pivot.html) ```sql %%sql CREATE TABLE Cities (Country VARCHAR, Name VARCHAR, Year INT, Population INT); INSERT INTO Cities VALUES ('NL', 'Amsterdam', 2000, 1005); INSERT INTO Cities VALUES ('NL',...

FYI this is still a bug in 0.10.16 ```sql %sql SELECT TRIM(' padded '); ``` ```shell --------------------------------------------------------------------------- ValueError Traceback (most recent call last) Cell In[2], [line 1](vscode-notebook-cell:?execution_count=2&line=1) ----> [1](vscode-notebook-cell:?execution_count=2&line=1) get_ipython().run_line_magic('sql',...

The caveat is with respect to example 1 where the Windows path contains Unicode characters (backslashes) so the user will need to either prefix the string with 'r' so that...

Here is the command and error message I get when trying the %sql connection option (using the raw string also fails). Command: ``` %sql duckdb:///"C:\Users\dwayn\Documents\DataCamp - Career Track - Data...

@soobrosa - Have you tried using `WHERE ISNAN(wordword_id)` instead of using `where wordword_id = 'nan' ` FYI - I came for another reason but saw your post and tried it...

I also ran into this with `read_csv` and the `%B %-d, %Y` dateformat pattern with version 1.0.0. `strptime` does the conversion correctly.

Having a more useful error message for new users would be nice, currently we get: ```shell Catalog Error: Type with name SERIAL does not exist! Did you mean "JSON"? ```...