[PROPOSAL] new raw SQL action

[youen]

Motivation

Some simple sql queries have better optimization than LINO'pull algorithm (such as DISTINCT).

Proposal

This is a proposal to add a new sql action. SQL query is read from standard input and result is dump as jsonline in standard output.

Example

$ echo "select * from public.customer" | lino sql source
{"id" : 1,  "name":  "Robert"}
{"id" : 2,  "name":  "Nick"}
...

[adrienaury]

How would insert or update statement work ?

Insert with returning clause

$ echo "insert into public.customer(...) values (...) returning id" | lino sql source
{"id" : 15}