Dumping and exporting DB with drush and piping to ZIP

If you want to import DB that is in ZIP format with one line

gunzip -c my_db.sql.gz | drush sqlc

to dump DB to ZIP file write this

drush sql-dump --gzip --result-file=my_db.sql

you will end up with my_db.sql.gz file.

------------------------------------------------------------------------

Additional command to import some SQL into current DB

drush sql:query --file="demo.sql"