Is it possible to get a JSON response from SQL with nested child tables?

Question

PHP

Decided to learn SQL, used MongoDB under NodeJS with ODM Mongoose. There it was possible to set the dependencies of the collections and, if necessary, pull them up for a specific field.
The result was something like this

{
    "user": {
        "username":"blablabla",
        "documents": [{...}, {...}] // собственно колекция которую можно подтянуть
    }
}

Is it possible to get something like this in SQL or is it already a task of the programming language?

Answer 1

well, do require with the right path and that's it .. :-)

Answer 2

If your vendor folder is in the same directory as the executable script, then:
require_once("vendor/autoload.php");
then write use if necessary
Not an answer to the question, but if anyone needs to install composer on Centos 7 blog.ivru.net/?id=83

Answer 3

like this?
https://docs.microsoft.com/en-us/sql/relational-da...