Wolfram Language Paclet Repository
Community-contributed installable additions to the Wolfram Language
The page title
SQL Operators
Demo
Demo
Install paclet
Install paclet
In[13]:=
PacletInstall["DamianCalin/SQLOperators"];Needs["DamianCalin`SQLOperators`"]
Get demo data using FinancialData package
Get demo data using FinancialData package
SQL operators
SQL operators
projectSQL (distinctSQL)
projectSQL (distinctSQL)
selectSQL
selectSQL
In[22]:=
(*Selectasubsetofcolumns*)selectSQL[sampledataSQL,{symbol,close}]//showTableSQL
In[23]:=
close=6;(*globalsymbolshavingthesamenameascolumnsarenotimpacted*)time="r"selectSQL[sampledataSQL,{close,time}]//(*here"close"isevaluatedintablecontext*)showTableSQL
In[26]:=
selectSQL[sampledataSQL,{3,1}]//(*youcanselectonordinalpositionsofcolumns*)showTableSQL
In[27]:=
selectSQL[sampledataSQL,{All}]//(*Allselectsallcolumns*)showTableSQL
In[27]:=
selectSQL[sampledataSQL,{"close","time"}]//(*youcanusecolumnnamestrings*)showTableSQL
whereSQL, ordeBySQL
whereSQL, ordeBySQL
addColumnsSQL, rowMapSQL, rowTransformSQL
addColumnsSQL, rowMapSQL, rowTransformSQL
bindColumnsSQL , colMapSQL
bindColumnsSQL , colMapSQL
groupBySQL , summarySQL , summaryMapSQL
groupBySQL , summarySQL , summaryMapSQL
combining operators
combining operators
unnestSQL
unnestSQL
pivotSQL , unpivotSQL
pivotSQL , unpivotSQL
overSQL
overSQL
rank , denserank , ntile , lag
rank , denserank , ntile , lag
unionSQL
unionSQL
joinSQL, crossJoinSQL , leftjoinSQL
joinSQL, crossJoinSQL , leftjoinSQL
Summaries , cross -tabulation functionality similar to R
Summaries , cross -tabulation functionality similar to R
Split SQL table on given conditions
Split SQL table on given conditions
Define constraints on SQL table
Define constraints on SQL table
LeftJoin ,FullJoin , AntiJoin , SemiJoin
LeftJoin ,FullJoin , AntiJoin , SemiJoin
Recursive queries connectBySQL
Recursive queries connectBySQL
""