> Literate programming. For example: I can have a python snippet that when I evaluate, results would be piped it into another snippet in SQL that retrieves data from postgress, and then I can send a http request to a remote API based on what's in DB, and then use that to build a chart. Can you do that in Markdown?
I've found you can get pretty close if you combine it with Jupyter notebooks. When you use jupytext [1] or similar to synchronize the markdown and ipynb then it works quite nicely.
Oh and as far as LaTeX / exporting is concerned, just use pandoc, you can export it however you want basically.