PostgREST vs sql vs PostgREST_typed examples.md

Where - restrict by single item

employees?and=(employee_id.gt.2)

select * from employees e where employee_id > 2

Where - restrict by multiple criteria

employees?or=(employee_id.eq.3,employee_id.eq.5,employee_id.eq.7)&and=(employee_id.gt.4)

select * from employees e where (e.employee_id =3 or e.employee_id = 5 or e.employee_id = 7) and (e.employee_id > 4)

Where - Multiple lines

employees?or=(employee_id.eq.3,employee_id.eq.5,employee_id.eq.7)&and=(employee_id.gt.4)

select * from employees e where ( e.employee_id > 5 or employee_id < 4 ) and ( e.title_of_courtesy like 'Mr.' or e.title_of_courtesy like 'Dr.' )