SQL SELECT When Loading .dset Files

Feature requests
1

Hi,

Would it be possible to add the ability to use SQL SELECT syntax when loading dset files into EasyMorph, allowing users to specify which rows and columns to import.

This capability to make a dynamic selection in the loading process would be very useful.

Best regards,
Knut P

2

We’re actually considering adding filtering predicates in the import actions. It won’t be an SQL-like syntax, but it will be possible to add simple conditions, e.g. “Year = 2025” or something like that.

3

Hi,

That is great. I think that would be a good solution for the filtering of rows from a dataset. Do you expect to allow Parameters for the conditions as well?

4

Yes. It will probably look similar to the filtering conditions in the “Import OData” action where parameters and first column values can be used in filters.

5

Hi,
This is excellent. I’m really looking forward to test and use this functionality.