Implement my own simple sprunje query?

I’m not sure how to implement a sprunje that would return the result of the following SQL query …

SELECT user_id, r.name
FROM role_users ru
LEFT JOIN roles r ON r.id=ru.role_id

For example, is there a simple way to pass the literal query into the eloquent framework?

In case anyone stumbles into this question and is looking for the answer, I figured it out back in November and implemented several sprunjes here …

2 Likes