View images as query results
It is not up to the database engine to render an image or provide any visualisations - that work is performed by the client application receiving the data returned by the database engine.

What you want to look for is an IDE or query tool that has in-built visualisation capabilities. SSMS does not do this natively for SQL Server, but there are plug-ins and alternative tools that can do this (see this question).

For Oracle, SQL Developer is apparently capable of rendering BLOBs in the IDE. For other RDBMS you will need to research.