bin/console doctrine:query:sql "select * from user"
bin/console doctrine:query:dql --max-result 1 "select u from App\Entity\PersistenceModel\User u Where u.name='Francisco'" --hydrate array
bin/console doctrine:query:dql --max-result 1 "select u from App\Entity\PersistenceModel\User u Where u.name='Francisco'" --hydrate object
Same with test database:
bin/console doctrine:query:sql "select * from user" --env=test