Having done a manual migration via CSV file, I didn't have a populated table of migration data.
I'll tell you more: I had so many menus, categories, and URLs without any IDs
Then, I wanted a solution without considering the IDs, because having migrated JOOMLA, KUNENA, CCOMMENT, as you might imagine I had the IDs triplicated on every imported data.
example
/article-ID-joomla
/comment-ID-ccomment
/thread-ID-kunena
all three could have the same ID.
I had about 7000 301 URLs on htaccess. But I wanted to find a professional solution.
So why not make a solution where to redirect any URL with any ID (or no ID) to any other URL.
And this is where @AndyB proved its capabilities, with this awesome addon, you add all 301 URLs into your database table and like magic, all redirects work lightning-fast and like a wonder.
The power of this solution is that I can add more redirects when I need them, without being forcibly tied to the poor ID solution.
In short
With ID or without ID with this addon, you can make all the redirects you want.
https://xenforo.com/community/threads/redirect-old-urls-after-migration-from-joomla-kunena.186410/