Data Manipulation Functions

Beyond simply storing and retrieving data, SwartzDB includes powerful functions for modifying and analyzing stored information. Filtering functions allow users to extract relevant data based on specific conditions, while aggregation functions enable operations like counting, summing, or averaging values across datasets.

📄️ Filter Function

The filter function in SwartzDB allows selecting, transforming, and formatting specific fields from a dataset while applying operations like concatenation, case conversion, and arithmetic calculations.

📄️ Aggregate Function

The aggregate function in SwartzDB is used to perform calculations on a list of numeric values. It works seamlessly with the filter function when extracting numeric data.