# DSQL map examples

The following examples show different use cases that can be handled by DSQL maps.

For more information about the functions and clauses used in these examples, see the [Talend Data Shaping Language Reference Guide](https://help.qlik.com/talend/en-US/data-shaping-language-reference-guide/8.0).

### In this section

* [Mapping nested loops in a DSQL map](https://help.qlik.com/talend/en-US/data-mapper-user-guide/8.0-R2026-07/mapping-nested-loops-in-dsql-map)
* [Splitting a loop in a DSQL map](https://help.qlik.com/talend/en-US/data-mapper-user-guide/8.0-R2026-07/splitting-loop-in-dsql-map)
* [Unrolling a loop in a DSQL map](https://help.qlik.com/talend/en-US/data-mapper-user-guide/8.0-R2026-07/unrolling-loop-in-dsql-map)
* [Grouping elements](https://help.qlik.com/talend/en-US/data-mapper-user-guide/8.0-R2026-07/grouping-elements)
* [Using a choice element in the input](https://help.qlik.com/talend/en-US/data-mapper-user-guide/8.0-R2026-07/using-choice-element-in-input)
* [Using a choice element in the output](https://help.qlik.com/talend/en-US/data-mapper-user-guide/8.0-R2026-07/using-choice-element-in-output)
* [Using key/value pairs](https://help.qlik.com/talend/en-US/data-mapper-user-guide/8.0-R2026-07/using-key-value-pairs)
* [Mapping enumerated values in a DSQL map](https://help.qlik.com/talend/en-US/data-mapper-user-guide/8.0-R2026-07/mapping-enumerated-values-in-a-dsql-map)
* [Transforming hierarchical recursive data to flat CSV format](https://help.qlik.com/talend/en-US/data-mapper-user-guide/8.0-R2026-07/dsql-hierarchical-json-to-csv-example)