How to send an attachment without physically creating the file using command line in linux

I am trying to send an email with a CSV attachment, however it is not possible to locally create the file.

Is there any way to pipe the content to sendmail/mail in a way the data would appear as an attachment ?

Thanks a lot in advance.