find advanced / sql-editor

[john]

Is there a way to simplify very complex sql-queries,

for instante
use of comment
use views
use an already defined query from within another query
use parameters
use procedures

I cannot get anyone of these working