macro/inline table valued functions

Is there anything like a macro or an inline table valued function in postgres?

i.e I define a query as a function/macro and reuse the function in queries and the dbms will expand the function/macro to its definition, thus avoiding any overhead.

If not what is the closest thing?

Thanks