BUG: Failure to convert SQL query

[miriam-z]

Description

I tried using sqlitis to convert a SQL query and received an error.

Failing command (required)

FIXME: PASTE SQLITIS COMMAND AND FULL OUTPUT HERE
sqlitis "select value from camdummy.targets where date between '2020-01-01' and '2021-07-01' and name = 'MY_WEEKLY_GMV'"  

ERROR: Failed to convert SQL: select value from camdummy.targets where date between '2020-01-01' and '2021-07-01' and name = 'MY_WEEKLY_GMV'
invalid comparison clause: [<Builtin 'date' at 0x7FF8D015BBE0>, <Keyword 'between' at 0x7FF8D015BE20>, <Single ''2020-...' at 0x7FF8D015BEE0>, <Keyword 'and' at 0x7FF8D015BFA0>, <Single ''2021-...' at 0x7FF8D01660A0>, <Keyword 'and' at 0x7FF8D0166160>, <Comparison 'name =...' at 0x7FF8D0126E40>]

Any idea thanks as the original syntax works in psycopg2