added configuration and sql generator