Supported Statements

Data manipulation statements

Data definition statements

Transactional statements

Dolt supports atomic transactions like other SQL databases. It's also possible for clients to connect to different heads, which means they will never see each other's edits until a merge between heads is performed. See Using Branches for more detail.

Dolt has two levels of persistence:

1. The SQL transaction layer, where a COMMIT statement atomically updates the working set for the connected head

2. The Dolt commit layer, where commits are added to the Dolt commit graph with an author, a parent commit, etc.

Prepared statements

Access management statements

More information on how Dolt handles access management may be found in the access management page.

Session management statements

Utility statements

Compound statements