Just let me send a raw SQL query

[waldnzwrld]

Feature request

Is your feature request related to a problem? Please describe.

I cannot use for example distinct or other common methods used in database management and I would like the ability to simply pass a SQL query as a string.

Describe the solution you'd like

The ability to pass a raw sql query to the database without defining a function in postgres. Rpc is not a solution for me, it is a workaround.

Describe alternatives you've considered

I know I can define a function in postgres, but that is a suboptimal solution, especially within a changing ecosystem. My code should be able to handle it.

Additional context

No

[muratmirgun]

Hello, Thanks for issue. I will check this feature.

[kiwicopple]

PostgREST is designed for HTTP requests. If you want to communicate directly via SQL & the Postgres protocol you can use a postgres client (something like this: https://github.com/lib/pq)