As of March 2025, the answer is you can't. because mysql plugin mysqlx is disabled by default on AWS RDS. You could check by using this command myssql> show plugins;

Unless you could activate the plugins with console or https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin.html.

Reference:

https://stackoverflow.com/questions/65981814/mysqlx-plugin-unreachable-on-amazon-rds-mysql-8-0#:~:text=According%20the%20Amazon%20RDS%20user,far%20as%20I%20can%20tell.