writing sql/one liners in vim

sometimes, i find myself using vim to write long shell/ruby one liners or sql queries on multiple lines.

this is helpful for those times. it copies the visual selection to the clipboard as a joined single line (without modifying the visual selection in place).

vnoremap <silent> <Leader>y "+y:let @+ = join(map(split(@+, '\n'), 'substitute(v:val, "^\\s\\+", "", "")'), " ")<CR>

it turns this:

select
 username, 
 machine, 
 count(*)
from 
 v$session
where 
 machine != 'db1'
group by 
 machine,
 username
order by
 machine

into this:

select username, machine, count(*) from v$session where machine != 'db1' group by machine, username order by machine