SQLOPS would work.  The difficulty is in writing your rules in your query.  Implementing the query and getting results in Kamailio is trivial if that’s done.  If your rules are strictly based on matching prefixes (which is pretty common in telephony) and you’re using postgres, the prefix opclass is pretty helpful in making the queries more efficient:

https://github.com/dimitri/prefix

Kaufman

From: John Cahill <John.Cahill@Firstcomeurope.co.uk>
Sent: Thursday, April 13, 2023 4:57 AM
To: sr-users@lists.kamailio.org
Subject: [SR-Users] CLI & destination based LCR

CAUTION: This email originated from outside the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.

Hi,

I'd like to build an LCR solution that routes on both CLI & destination e.g.

CLI matches ^\+49*, destinations matches ^\+44* => route to gateway 5

for a large rule set (~ tens of thousands). Any recommendations for which modules to use? Can kamailio perform this particular task well or should I look at another solution? I'd be very grateful to hear about any experience of doing this. Many Thanks.

Regards,

John