Non-standard handcrafted SQL operations are the most flexible type of operation provided by the generator. They allow the developer to specify custom parameters and SQL for the operation. No parameters are generated for ns operations except those provided by the developer. All parameters provided by the developer are replicated into all the generated layers of the application.
This type of operation is intended to be used for situations where none of the other operations are suitable. This includes joins across tables and queries which count or calculate max, etc.
These operations are represented by the following operation stereotypes: