added sql visitor functionality for assists