I am an ex SAS user. What I particularly liked about it, that it had a SQL compiler. I could write SQL code and get all the highlights, syntax errors and everything else that SAS had to offer but writing SQL. Had to migrate to R due to company change. Is there a good way to write SQL instead of R code? I tried sqldf package, its great, but its missing syntax highlights, error messages for missed commas etc.
Any suggestions, how can I make writing SQL easy and pleasant and possible?