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

[OneWithQuestion]

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 today's date, but I also want to filter on the sales person running the direct query.

Our sales table has the sale's person's userPrincipalName as a column but I want it to filter on that by passing a value as opposed to having to return all the values for today and then do a slicer filter on the report.