Support RLS statements

[wyozi]

Hey, I'm working on a project where I would like to parse and transform (among others) RLS policy migrations.

Namely, stuff like

create policy "authorize read access"
on "public"."accounting_entries"
as permissive
for select
to public
using (( SELECT authorize_company(accounting_entries.company_id) ));

and

drop policy "Users can update own profile." on "public"."profiles";

Would it be possible to add support for these?

[git-hulk]

@wyozi It would be nice if you can provide the documentation link to which dialect supports this syntax.

[wyozi]

Ah of course, this is Postgres dialect. I'm so used to working in the Postgres world that I sometimes forget how different the dialects are 😅

Here's the documentation: https://www.postgresql.org/docs/current/ddl-rowsecurity.html

[git-hulk]

@wyozi Thank you! I will support this when I get time.