Cédric L. Charlier
Cédric L. Charlier
Currently, the feature [filter with ranking](http://www.nbi.io/docs/resultset-alteration/#filter-with-ranking) doesn't support that you provide a definition of the way the result-set is ordered when filtering the rows. This improvement is providing this capability....
A `splice join` is a full `asof join` (see #653). It will return all the records from both tables. For each record from left table splice join will find prevailing...
When working with time-series and trying to join them the usage of ASOF joins (similar to [QuestDB documentation](https://questdb.io/docs/reference/sql/join#asof-join)) is extremely useful. This alteration is part of the category: merge &...
It should be possible to use the query tools `q.exe`, `jq.exe` or `http-prompt.exe` and redirect the stdout to get access to their results in a `json-source`.
This feature is useful when you've some transformations but you are not sure that some of the columns used in the transformation always exist or you fear that the value...
This feature is useful when you've some transformations but you are not sure that some of the columns used in the transformation always exist. The syntax `[foo] ? [bar] |...
With this new alteration, all columns are transformed into rows and all rows into columns. ```xml ``` The following result-set #0 | #1 | #2 ---------|------|----- France | Germany |...
It should be possible to assert that a row with a specific index is validating or not a predicate. ```xml Total ``` It should also be possible to check the...
Predicate comparing the actual length of a _text_ to the length of another _text_.
Should be possible to assert if a _dateTime_ is a specific weekday or the first/last day of a month/year.