Hi Xano!
I have a situation where I need to compare two different arrays of UUIDs with OVERLAPS: one array coming from my web frontend and one from a column typed UUID in my database. OVERLAPS is the only operator I can use given the make-up of my arrays (CONTAINS, for example, won't work since many times there will be only one common UUID in each array that is the same). Since OVERLAPS is typed, it won't compare the string UUIDs coming from the frontend. Unfortunately, there's not really another easy way to pass UUIDs from a frontend. Also, it's not easy to convert the UUID string array to the UUID type array used in Xano via the function stack. The best hack is to do a loop and compare all individual elements in the arrays with the expression builder. That works, but then you also need to use the expression building for sorting, pagination, etc. It's a solution, but not that elegant in my opinion.
Hence the uuid() function idea! Pass an array of UUID strings to it, it normalizes them the the database UUID type and then you can evaluate the two arrays with OVERLAPS work.
Todd