Yes. you can use org-mode to create a living 'literate code' document of database connections and queries. You can then execute the queries directly from this document.
Yes, it is. You will benefit greatly from the tight integration between shells, remote file editing, database support (albeit fairly simple, compared to dedicated tools) and obviously an excellent editing environment in general.
Beware! I, too, started as a data analyst taking notes in org-mode and before I knew it I ended up a software developer.
Absolutely. While I've been trying to do more coding in emacs, I primarily use it for various interactive shell stuff, file management, project management, time tracking, todos, calendar, journalling/loggin, and the occasional remote file editing (Through the TRAMP package).