mysema/querydsl — Issue #35: Add support for table-valued functions
Author: nyc2
Created: 2011-11-01 10:52:02+00:00
State: open

Some database systems provide user defined functions that return table values. Those table values can be joined with other relational objects like tables or views. The main advantage is the possibility to make use of parameters in those user defined functions.

An exemplary implementation of this kind of user defined functions is Microsoft SQL Server's Table-Valued User-Defined Function (see http://msdn.microsoft.com/en-us/library/ms191165.aspx). Querydsl support would be a great benefit.

Maybe, Querydsl's RelationalPath can be extended in a way that supports parameters and allow the generation of SQL like select * from Table t join TableValuedFunction(?, ...) tvf on tvf.value=t.value.