This is the twenty first part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation We have all things to transform rows and columns. Now it is time to implement SELECT clause. We have two ways: either we use aggregates or … Continue reading SQLxD Part 21 — SELECT

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