REST API DESIGN

Here is a humble list of what we think that might be good to have in our toolset.

RESOURCE ACTION /list (list.php)

localhost/db/list/table1/id-field/{left,right,inner}/table2/id-field/{left,right,inner}/table3/id-field

{ list : { resource : table1 id-field : id-field, params : {left,right,inner}, resource : table2 id-field : id-field, params : {left,right,inner}, resource : table3 id-field : id-field } }

select * from table1 {left,right,inner} table2 {left,right,inner} table3 where table1/id-field = table2/id-field and table2/id-field = table3/id-field

localhost/db/list/table1/id-field/{left,right,inner}/table2/id-field/{left,right,inner}/table3/id-field/table1/id-field2

{ list : { resource : table1 id-field : id-field, params : {left,right,inner}, resource : table2 id-field : id-field, params : {left,right,inner}, resource : table3 id-field : id-field params : { resource : table1 id-field : id-field2 }, } }

select * from table1 {left,right,inner} table2 {left,right,inner} table3 where table1/id-field = table2/id-field and table3/id-field = table1/id-field2

What about YQL ?