fastq-dump using mkfifo to stream data
fastq-dump can write to stdout ; the -Z option allows you to do that. This, you can pipe to any downstream process. [An example]. Also see the SRA-toolkit manual.

I guess someone asked this question in biostar too.