Not exactly.
I’ve changed all occurences of ‘[[:<:]] and ‘[[:>:]] to ‘\\\\b as you need double the backslash because MySQL interprets it as the escape character within strings.
But that didn’t help, another error was that d.post_title is unknown. So I’ve changed ‘d.post_title’ to just ‘post_title’. And now it works!
For a fix best would be to determine version of MySQL for example by:
$mysqlVersion = $wpdb->db_version();
Mine is 8.0.22 and then serve right word boundaries.