PostgREST can look closer to SQL. For example this query:

  select
    time,
    device_id,
    humidity
  from conditions
  where
    humidity > 90           and
    time     < '2016-11-16'
  order by time desc
  limit 10;

Can be expressed as this request:

  curl -G "/conditions" \
  -d select=time,device_id,humidity \
  -d humidity=gt.90 \
  -d time=lt.2016-11-16 \
  -d order=time.desc \
  -d limit=10

In long form without curl:

  /conditions?select=time,device_id,humidity&humidity=gt.90&time=lt.2016-11-16&order=time.desc&limit=10

Taken from: http://postgrest.org/en/v5.2/integrations/timescaledb.html#p....