Wolfram Language Paclet Repository

Community-contributed installable additions to the Wolfram Language

DamianCalin/ SQLOperators

Provide the simplicity of SQL in Wolfram language. For demos check: https://community.wolfram.com/web/damcalrom/home

Contributed by: Damian Calin

Installation Instructions

To install this paclet in your Wolfram Language environment, evaluate this code:
PacletInstall["DamianCalin/SQLOperators"]


To load the code after installation, evaluate this code:
Needs["DamianCalin`SQLOperators`"]

Details

See guide section

Examples

Basic Example

Using groupBySQL/summarySQL:

In[1]:=
sampledataSQL // groupBySQL[# , {symbol} ] & // summarySQL [# , Association["maxclose" :> (close // Max) , "minclose" :> (close // Min) , "count" :> (close // Length) , "histogram" :> (close // Histogram) , "dateplot" :> (Thread[{time, close}] // DateListPlot) , "boxplot" :> BoxWhiskerChart[close ] ] ] & // showTableSQL
Out[1]=

For more examples see guide section or https://community.wolfram.com/web/damcalrom/home

Publisher

Damian Calin

Compatibility

Wolfram Language Version 13.

Version History

  • 1.0.4 – 29 November 2023
  • 1.0.3 – 23 November 2023
  • 1.0.2 – 26 September 2022
  • 1.0.1 – 22 September 2022
  • 1.0.0 – 22 September 2022

License Information

MIT License

Paclet Source