Does the .NET Editor support SQL Server's CROSS APPLY?
Does the .NET Editor support SQL Server's CROSS APPLY?
pcjackson
Posts: 18Questions: 6Answers: 0
aka PostgreSQL's and MySQL's LATERAL join.
I have a table valued function that generates a recursive query based on an input, and I want to join that to my record set using Editor's .NET API. Is this supported? If not, would a pull request be accepted to add it?
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
No sorry. The only type of join that is supported with the libraries API is a simple left join. That said, you could use a VIEW to build the query you want and have the libraries read from that, but write to a given table.
Pull requests are always welcome. If it will be accepted will depend upon its maintainability and what it would take to add that feature into the PHP and NodeJS libraries as well. Very happy to talk about any ideas you have before you start working on it if you like!
Allan
Using a view like that is a completely acceptable workaround for me. In fact, I can't really imagine a scenario in which it wouldn't work, no matter how complex the query. Thanks!