parameters default to None rather than list() and granular execute for postgres