Is there a way to implement row numbers or other window functions within the query building block tool?
You can’t explicitly request window functions from the query builder, but it will use them for certain aggregate functions (the cumulative ones).
For row numbers you can use cumulative sum on a constant ‘1’ column to generate them.
You can also define a Model that uses window functions to generate columns then process the results from the query builder.