If Beam SQL does not have a built-in function to meet your needs, you can create your own user-defined functions (UDFs) and user-defined aggregate functions (UDAFs) in Java and invoke them in your SQL ...
ZetaSQL supports user-defined functions (UDFs). A UDF enables you to create a function using another SQL expression or another programming language, such as JavaScript. These functions accept columns ...