# Advanced Query Topics

The following topics give more information querying features are available beyond the basic `SELECT` statement. Then, we will explain some functionalities that will maintain the integrity of your data and how you can set some controls on how data is interpreted, compiled, or locked. Finally, this section gives a real-life example and takes you through the steps of creating a database to running analytics.

## In this section

* [Performing Upserts](https://docs.singlestore.com/db/v9.1/query-data/advanced-query-topics/performing-upserts.md)
* [WITH (Common Table Expressions)](https://docs.singlestore.com/db/v9.1/query-data/advanced-query-topics/with-common-table-expressions.md)
* [Read Query Results in Parallel](https://docs.singlestore.com/db/v9.1/query-data/advanced-query-topics/read-query-results-in-parallel.md)
* [Row Locking](https://docs.singlestore.com/db/v9.1/query-data/advanced-query-topics/row-locking.md)
* [Two-Phase Transaction Commit](https://docs.singlestore.com/db/v9.1/query-data/advanced-query-topics/two-phase-transaction-commit.md)
* [Example: Building a Sample Stock Trade Database](https://docs.singlestore.com/db/v9.1/query-data/advanced-query-topics/example-building-a-sample-stock-trade-database.md)
* [Code Generation](https://docs.singlestore.com/db/v9.1/query-data/advanced-query-topics/code-generation.md)

***

Modified at: May 14, 2026

Source: [/db/v9.1/query-data/advanced-query-topics/](https://docs.singlestore.com/db/v9.1/query-data/advanced-query-topics/)

(An index of the documentation is available at /llms.txt)