Is there a way to bypass sql?

I have been digging into NoSQL of late.  For navigational queries it 
would be great if there was a way to bypass SQL and directly pull from 
an identifier for a record or arbitrary byte stream.  Does postgresql 
directly support such ability?   What is the closest that you could come?

- samantha