Pass username as filter or parameter in query using DirectQuery to SQL?

Is there anyway to pass UserName() or userPrincipalName() as a query parameter when doing direct query?   For example, if I want to direct query on today's sales I can handle queries like getting t...