ensure that dialect is set properly

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