SQLP examples with stdin

[slonyik]

Could you please add example of polars/sqlp using the stdin, please ?

cat file.cvs | qsv sqlp - 'select * from stdin'

it took me a while to find out the syntax
having it in the sqlp help might spare time for others.

Thanks

[ondohotola]

RTFM :-)-O see issue #1026 and you can do something like

cat file.cvs | qsv rename _all_generic | qsv  sqlp -Q - 'select _col_1 as A, _col_2 as B from stdin' 

and pipe (take) it from there

[slonyik]

Thanks @ondohotola 👍

The ask here is to add that example to the help* text of sqlp.

Truth is, I did not read/search the discussions just code/repo search - my fault.

• help i.e. the M in RTFM ;-)

[jqnatividad]

And I also added an example for stdin and read_ndjson as well.

64c85ae

FYI, Polars SQL is evolving quite fast and the documentation on it is still a bit sparse, that's why I linked to this tracking issue from sqlp usage text.

pola-rs/polars#7227

[slonyik]

👍
Thanks !