Yup. You can either write the entire query yourself or supply parts of the query to the ORM:
https://laravel.com/docs/11.x/queries#raw-expressions
https://medium.com/@aiman.asfia/deep-dive-into-raw-queries-in-laravel-unveiling-the-power-beneath-eloquent-0cf3bdde7f73
Eric P /
npub1z6…0amwj
2024-07-24 03:33:06
in reply to nevent1q…h3j3
Author Public Key
npub1z6g2q9jtj3zg8598lzcq2dgffgjprx9nljax0gzxzp3r3jjwa6pq20amwjPublished at
2024-07-24 03:33:06Event JSON
{
"id": "6c40cb27905dfd457dbd97da2b5a27456472f4a3227c08588d7c4352f06d5b7b",
"pubkey": "1690a0164b944483d0a7f8b00535094a241198b3fcba67a046106238ca4eee82",
"created_at": 1721791986,
"kind": 1,
"tags": [
[
"p",
"1e2637ad71db45378ad68094115f1128cd32bddb5d080ffd44f3518f4583cbfb"
],
[
"e",
"6579a68f3048a670a273a15c0dbd5f4ff23a0773af9fa6945e1e74f7f0d1d82a",
"",
"root"
],
[
"e",
"61520cdd4a3d9e03976bd0af69dc481dc52babe106b19c4936457c9e057f351b",
"",
"reply"
],
[
"proxy",
"https://podcastindex.social/@ericpp/112839359594740389",
"web"
],
[
"p",
"1690a0164b944483d0a7f8b00535094a241198b3fcba67a046106238ca4eee82"
],
[
"proxy",
"https://podcastindex.social/users/ericpp/statuses/112839359594740389",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://podcastindex.social/users/ericpp/statuses/112839359594740389",
"pink.momostr"
],
[
"-"
]
],
"content": "Yup. You can either write the entire query yourself or supply parts of the query to the ORM:\n\nhttps://laravel.com/docs/11.x/queries#raw-expressions\n\nhttps://medium.com/@aiman.asfia/deep-dive-into-raw-queries-in-laravel-unveiling-the-power-beneath-eloquent-0cf3bdde7f73",
"sig": "086321d95888a4c3c4aafd12e012214004e971bef58f60b02bd317c23b412e24abcafb8b9e6676f6a7538cf9829d93e9287e20cc494caa4ccd6db3dc1f72acf1"
}