Translator basic tests

This PR is the basic tests over the Translator and the fixes. We should create more tests and review the constraints that the dynamic SQL statement generator have now, if it worth to work more on it to cover other scenarios