You can write your own custom SQL functions and use them in formulas and in your SQL queries.

<aside> ☝ Note: this only applied to SQL queries running on Peliqan’s query engine Trino !

</aside>

Custom functions are a great way to implement specific transformations, implement business logic, validate data etc. For example you could write a custom function to validate phone numbers or bar codes, to calculate product pricing or to feed a machine learning model.

Go to Admin > Database functions.

Add a new function, use only lower case for the function name, no spaces.

Next, write your anonymous function in Javascript. Maximum 5 parameters are allowed.

Here’s a simple example:

(param1, param2) => {
  return param1 + param2;
}

Once done, you can use your custom function in any SQL query.

Example for the above function, that was saved using the name “my_func”:

SELECT **my_func(price, vat)** AS total_price, product_name FROM products