You can use a function created in a standard module in any query in the database.

Standard Module

In programming, a code module that contains collections of functions, procedures, and definitions to be used across different parts of a program or application.

Database

An organized collection of structured information or data, typically stored electronically in a computer system.