I think that point is about it not supporting streaming compression where the output of the packer is immediately fed into something like a pipe or a TCP connection.

You can do this with both tar and ZIP. If all you have is SQLite, you need to fully create the local database (be it in a file or in memory) before you can transmit it somewhere else to be stored or unpacked.