This is the twentieth part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation We can extract nodes, transform them into rows, filter, join, group, order, and transform them. It is high time to glue all the things together in order … Continue reading SQLxD Part 20 — Transformers

This is the nineteenth part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation Last time we implemented expressions, it is high time to test them: Having expressions working we can use them in transformers. This is the topic of the … Continue reading SQLxD Part 19 — Expressions tests

This is the eighteenth part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation Last time we saw tests for aggregates. Today we are going to implement expressions. We can compare columns with different value types: numbers, dates, strings. However, it … Continue reading SQLxD Part 18 — Expressions

This is the seventeenth part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation Last time we implemented aggregates, today we test them. Here are the snippets: That’s all. In the next part we will implement various functions for dates, strings, … Continue reading SQLxD Part 17 — Tests for aggregates

This is the sixteenth part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation Today we implement various aggregates. Let’s start with the interface: We can see that the aggregate returns one cell for whole relation. You might wonder why is … Continue reading SQLxD Part 16 — Aggregates