没有RDB也敢揽SQL活的开源金刚钻SPL

$select* fromd:/Orders.csv whereAmount>=100

$select* fromd:/Orders.csv whereClientlike'%bro%'

$select* fromd:/Orders.csv whereClientisnull

$select* fromd:/Orders.csv wherenotAmount>=100andClientlike'bro'orOrderDate isnull

$select* fromd:/Orders.csv whereClientin('TAS','KBRO','PNS')

$select* fromd:/Orders.csv where(OrderDate<date('2020-01-01') andAmount<=100)or(OrderDate>=date('2020-12-31') andAmount>100)

$selectround(Amount,2), price*quantity fromd:/Orders.csv
$selectleft(Client,4) fromd:/Orders.csv
$selectyear(OrderDate) fromd:/Orders.csv

$selectcaseyear(OrderDate) when2021then'this year'when2020then'last year'else'previous years'endfromd:/Orders.csv

$selectcoalesce(Client,'unknown') fromd:/Orders.csv

$selectOrderId, Amount, OrderDate fromd:/Orders.csv

$select* fromd:/Orders.csv orderbyClient, Amount desc

$selectdistinctClient,Sellerid fromd:/Orders.csv

$selectyear(OrderDate),Client,sum(Amount),count(1) fromd:/Orders.csv 
groupbyyear(OrderDate),Client
havingsum(Amount)<=100

$selectavg(Amount) fromd:/Orders.csv

$selecto.OrderId,o.Client,e.Name e.Dept,e.EId fromd:/Orders.txt o 
leftjoind:/Employees.txt e ono.SellerId=e.Eid

$selecto.OrderId,o.Client,e.Name e.Dept,e.EId fromd:/Employees.txt e 
rightjoind:/Orders.txt o ono.SellerId=e.Eid

$selecto.OrderId,o.Client,e.Name e.Dept,e.EId fromd:/Employees.txt e 
fulljoind:/Orders.txt o ono.SellerId=e.EId

$selecto.OrderId,o.Client,e.Name e.Dept fromd:/Orders.csv o 
innerjoind:/Employees.csv e ono.SellerId=e.Eid

$selecto.OrderId,o.Client,e.Name e.Dept fromd:/Orders.csv o ,d:/Employees.csv e 
whereo.SellerId=e.Eid

$selectt.Client, t.s, ct.Name, ct.address from
(selectClient,sum(amount) s fromd:/Orders.csv groupbyClient) t 
leftjoinClientTable ct ont.Client=ct.Client

$witht as(selectClient,sum(amount) s fromd:/Orders.csv groupbyClient)
selectt.Client, t.s, ct.Name, ct.address fromt 
leftjoinClientTable ct ont.Client=ct.Client

$select* fromd:/Orders.txt o  whereo.sellerid in(selecteid fromd:/Employees.txt)

$selectprice*quantity assubtotal fromd:/detail.csv

Select* fromOrders1.csv
Unionall
Select* fromOrders2.csv

$selectdept,count(1) c,sum(salary) s intodeptResult.xlsx fromemployee.txt groupbydept havings>100000

$select* fromd:/Orders.txt whereAmount>=100andClientlike'bro'orOrderDate isnull

$select* from{file("d:/Orders.txt").import@t (;":")} 
whereAmount>=100and Client like 'bro'or OrderDate isnull

$select* from{file("d:/Orders.txt").import()} where_4>=100and_2 like'bro'or_5 isnull

$selectyear(OrderDate),sum(Amount) from
{file("d:/Orders.txt").import@t (orderid,client,sellerid,amount,orderdate:date:"dd-MM-yyyy")}
groupbyyear(OrderDate)

$select* fromd:/Orders.xlsx whereAmount>=100andClientlike'bro'orOrderDate isnull

$select* from{file("D:/Orders.xlsx").xlsimport@t (;"sheet3")} 
whereAmount>=100and Client like 'bro'or OrderDate isnull 

$select * from {httpfile("http://127.0.0.1:6868/Orders.csv).import@tc() } 
where Amount>=100 and Client like 'bro' or OrderDate is null

$select* from{json(file("d:\\data.json").read())} 
whereAmount>=100andClientlike'bro'orOrderDate isnull

$select* from{json(httpfile("http://127.0.0.1:6868/api/getData").read())}
whereAmount>=100andClientlike'bro'orOrderDate isnull

$select* from{xml(file("d:/data.xml").read(),"xml/row")}
whereAmount>=100andClientlike'bro'orOrderDate isnull

$select* 
from{ws_call(ws_client("http://。/entityWS.asmx?wsdl"),"entityWS ":" entityWSSoap":"getData")} 
whereAmount>=100andClientlike'bro'orOrderDate isnull

$select* from
{mongo_shell@x (mongo_open("mongodb://127.0.0.1:27017/mongo"),"main.find()")}
whereAmount>=100andClientlike'bro'orOrderDate isnull

$select* from{sf_query(sf_open(),"/services/data/v51.0/query","Select Id,CaseNumber,Subject From Case where Status='New'")} whereAmount>=100andClientlike'bro'orOrderDate isnull

$selecto.OrderId,o.Client,e.Name e.Dept fromd:/Orders.csv o innerjoind:/Employees.xls e ono.SellerId=e.Eid

selectmax(continuousDays)-1
from(selectcount(*) continuousDays
from(selectsum(changeSign) over(orderbytradeDate) unRiseDays
from(selecttradeDate,
casewhenprice>lag(price) over(orderbytradeDate) then0else1endchangeSign
fromAAPL) )
groupbyunRiseDays)

D:\raqsoft64\esProc\bin>esprocx.exe -R select Client,sum(Amount) from d:/Orders.csv group by Client
Loglevel:INFO
ARO899.0
BDR4278.8
BON2564.4
BSF14394.0
CHO1174.0
CHOP1420.0
DYD1242.0
…

…
Class.forName("com.esproc.jdbc.InternalDriver");
Connection conn =DriverManager.getConnection("jdbc:esproc:local://");
PrepareStatement st = conn.prepareStatement("$select* from employee.txt where SALARY >=? and SALARY<?");
st.setObject(1, 3000);
st.setObject(2, 5000);
ResultSet result=st.execute();
...

…
Class.forName("com.esproc.jdbc.InternalDriver");
Connectionconn =DriverManager.getConnection("jdbc:esproc:local://");
Statementst = connection.();
CallableStatementst = conn.prepareCall("{call getQuery(?, ?)}");
st.setObject(1,3000);
st.setObject(2,5000); 
ResultSetresult=st.execute();
...