Write APIs using direct SQL queries with no hassle, let's rethink about SQL

How would this compare to using something like postgrest and using normal triggers/checks/RLS for validation?