OneLake Security RLS | Join tables and Call Username function

Our team would like join to our security mapping table in the rule and call the employee that is querying's username and filter by it. It would look like:

select * from my_table
inner join security_table
on security_table.projectID = my_table.projectID
where security_table.username = username()

This would allow us to dynamically set our RLS on the table.