Up until now, we have been creating new connections to interact with substrait. This was necessary to circumvent the client context lock.
However, this was a brittle solution and especially problematic when dealing with temporary objects since these are not passed around new connections.
This PR allows us to reuse the same connection by utilizing a new flexible relation binder that allows us to consume and execute substrait plans from within the same connection; it also changes the from_substrait functions to use bind replace.
Aditionally, extracting plans will also go through a specialized code path, to allow us to use the same connection.
Since substrait also uses special options (e.g., some optimizations are disabled), these are set and reset on the original connection.
Up until now, we have been creating new connections to interact with substrait. This was necessary to circumvent the client context lock.
However, this was a brittle solution and especially problematic when dealing with temporary objects since these are not passed around new connections.
This PR allows us to reuse the same connection by utilizing a new flexible relation binder that allows us to consume and execute substrait plans from within the same connection; it also changes the
from_substraitfunctions to use bind replace.Aditionally, extracting plans will also go through a specialized code path, to allow us to use the same connection.
Since substrait also uses special options (e.g., some optimizations are disabled), these are set and reset on the original connection.