Wolfram Language Dataset objects allow arbitrary hierarchical data on which a rich set of possible operations can be applied. Dataset objects can also directly represent traditional relational databases, on which Wolfram Language functions can be used to perform traditional SQL-like operations.

Select — SQL WHERE

GroupBy — SQL GROUP BY

Counts, CountsBy — SQL COUNT

Insert, Append — SQL INSERT

Delete, Drop — SQL DELETE

DeleteDuplicates — SQL UNIQUE

Union, Catenate, Merge — SQL UNION

JoinAcross — SQL JOIN