What is the best text editor for HTML/XHTML/CSS/PHP/SQL on Ubuntu?

I just switched over to Ubuntu from OSX (where I used Panic Coda for dev; loved loved it) and now I am a little unsure of the apps available for Ubuntu. Trying Bluefish and PHPAnywhere (web app) but they seem to be lacking in the SQL support. I don’t mind paying for something that is great. But…what is it?