updated plugins to match raw sql