This part of the documentation is intended for developers looking for information on how to write SQL statements in their own project.
There are multiple ways to structure your SQL files - choose whatever fits best to your project. Each of your
.sql files can have an optional front matter part that can be used to fine-tine a single SQL statement. Depending on the persistence API you have picked, SQL statements can be configured to return types from your project in order to improve the type-safety of your code. There is some general information about those converters, however each persistence API usually has its own little quirks that you can read upon in their individual sections.