UsageError: unrecognized arguments: ->

[tekumara]

What happens?

UsageError: unrecognized arguments: -> '$.id'

To Reproduce

%load_ext sql
%config SqlMagic.feedback = False
%config SqlMagic.displaycon = False
%config SqlMagic.autopandas = True
%sql duckdb:///:memory:
%sql SELECT json('{"id": "a"}') -> '$.id'

OS:

macos

JupySQL Version:

0.10.7

Full Name:

Oliver Mannion

Affiliation:

Xero

[tekumara]

Another variant using %%sql

%%sql SELECT json('{"id": "a"}') -> '$.id',
json('{"id": "b"}') -> '$.id'

produces:

UsageError: Unrecognized argument(s): ->

[tekumara]

Similar to #918

[tekumara]

Workaround:

%%sql
SELECT json('{"id": "a"}') -> '$.id',
json('{"id": "b"}') -> '$.id'

[edublancas]

@bryannho can you take a look? I thought that the fix you implemented which used SQL keywords to detect where the query begins should address this

[bryannho]

@edublancas yes, this should have been caught! looking into it now