DB: Table-Valued Function Support

Connecting to SQL
1

I would love know how progress is going on further extended table-valued function support. ie.
SELECT * FROM tableFunction(param1) WHERE param2 = ‘etc’

I did notice this commit which implements basic handling to the SQLSRV module, however it isn’t filterable which is a big gap in functionality.

Cheers,

Dean

2

HI Dean. I actually worked on the table valued function support and submitted the code for inclusion, we didn’t need the filter support at the time but I would be happy to work on it and see if I can get it pulled into the development branch.

3

Excellent, it is a feature that would nicely fill the gap between the limitations of views and stored procedures when working with SQL Server.

Cheers,

Dean

4

Hi,

Did this update ever reach a production release?
I’m specifically looking to use the max() function on a table column that holds a date.

Regards