ensure that dialect is set properly

some nodes (join, in this case) did not have the proper sql instance set on them.