Named point in the transaction log? Does it exist?
You can use a Log Mark to enable a restore to specific logical point-in-time of a database, but you can't use that in queries to the main database.

You can take a Database Snapshot to present a point-in-time consistent copy-on-write snapshot of an existing database.