DDL drop table: Switch error message to warning type

[Donnerstagnacht]

Bug report

• I confirm this is a bug with Supabase, not with my own application.
• I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

As discussed in #365

If I write a drop table statement, it is technically correct code:

But it creates the following error:

Dropping a table may break existing clients.

To Reproduce

Steps to reproduce the behavior, please provide code snippets or a repository:

1. Create a table and drop it

DROP TABLE IF EXISTS public.groups;
DROP TABLE IF EXISTS groups;

Expected behavior

Error should be a hint or a warning instead of an error since this statement may be intended and therefore correct.

System information

• OS: windows 11
• editor: vs-code
• pls: 0.5.0

Additional context

Another option could the intended and planned pls annotation:
// @pg-ignore