mo-sql-parsing icon indicating copy to clipboard operation
mo-sql-parsing copied to clipboard

Non-ASCII characters in identifiers without quotes raise ParseException (PostgreSQL).

Open a1ea321 opened this issue 6 months ago • 3 comments

This works in PostgreSQL 16:

create view public.delete→me as (select 42);
select * from public.delete→me;

So I expected this to work as well:

from mo_sql_parsing import parse as p
p('select * from public.delete→me;')

But it raises a ParseException. With quotations it works fine:

 p('select * from public."delete→me";')

But I don't want to use quotation marks. It may be that mo-sql-parsing is trying to nudge me towards better practices, of course. :)

pip show mo-sql-parsing says: Version: 10.652.24214

a1ea321 avatar Aug 08 '24 14:08 a1ea321