When you say 'mapped version', do you mean when using Apache directive:
DocumentRoot site.php
If you do this, $_SERVER['REQUEST_URI'] will contain the complete URI as requested by the client.
The problem with this method is that the rest of your Apache configuration for the server (or VirtualHost) becomes redundant.
One thing I have done in the past is use RewriteRules to map URIs to query strings for PHP scripts:
RewriteRule /([/])/({.]).(.*)$ http://domain.com/getRecord.php?table=$1&id=$2&format=$3 [NC]
which works but is a bit clunky.
Essentially, Apache configuration files are suited to this task. They are not programming languages and don't have variables or other such features.
(The original question was inspired by Cocoon which allows you to work with URI 'patterns' and extracts matches from these regular expressions as variables which you can go to use in the configuration file; you can create a 'virtual directory structure'.)