> Perhaps this is in reference to nested data structures

If you have nested data structures then it violates 1NF, i.e. the data isn't normalised.

Any "pure" RDBMS won't even be able to represent that denormalised data in a table, let alone query it with SQL. Normally this is worked around by straight up serialising it. Obviously some implementations have extensions, like Postgres has JSON columns.