Note for people who have “complex” table requirements, another workflow would be to extend markdown using something Quarto. This enables you to use R code to load data and generate very beautiful tables using libraries like kable, or gt:
https://haozhu233.github.io/kableExtra/
This isn’t for everyone of course, it requires some knowledge of coding (in this case R, but I’m sure there is some tools for Python too), however it enables some very complex conditional tables including local footnotes etc. that are auto-updated each time you compile your Scrivener project.