jOOQ and creating stored functions/procedures
Starting with version 3.15, jOOQ began to add an API for creating stored functions, procedures, and triggers. Among others, we have support for CREATE FUNCTION, CREATE OR REPLACE FUNCTION, CREATE PROCEDURE, CREATE OR REPLACE PROCEDURE, DROP FUNCTION, and DROP PROCEDURE.
Creating stored functions
For instance, creating a scalar function for MySQL can be done as follows:
Parameter<Integer> quantity = in("quantity", INTEGER);
Parameter<Double> listPrice = in("list_price", DOUBLE);
Parameter<Double> fractionOfPrice =
  in("fraction_of_price", DOUBLE);
ctx.createOrReplaceFunction("sale_price_jooq")
   .parameters(quantity, listPrice, fractionOfPrice)
   .returns(DECIMAL(10, 2))
   .deterministic()
   .as(return_(listPrice.minus(listPrice
     .mul(fractionOfPrice)).mul(quantity)))...
