We use static analysis to track the usage of function parameters. If any of them are used to compare against specific views or tables, we will pick a subset of rows from affected tables, then generate tests by populating the function parameters using the staging database data.

Validation compares function return values (which can also be data sets). Functions cannot write to tables nor change the values of the parameters.