RDS is an SQL database. This will allow you to query cross table.
Note: This plugin is recommended for more advanced users.
The most important benefit of using rds is all columns are queryable and sortable. Setting up indexes will boost the query speed, but even without indexes you can query any column.
You can sort the table with multi-columns. For example, if you have kda and level in a table, if you want to sort players with level, and two players have the same level, then sort them based on kda.
It's designed to execute sql from client. rds's administer account will be managed by aws security manager so it won't be exposed on the client and only your aws account can access it. It's safe to use it with cognito which is a implement of OAuth2 and open id.
Video Tutorial: https://www.youtube.com/watch?v=QIphNOFV0j0
SQL vs No-SQL Databases: https://www.youtube.com/watch?v=ZS_kXvOeQ5Y
Number of Blueprints: 2
Number of C++ Classes: 2
Network Replicated: No
Supported Development Platforms: Win64 / Mac(apple silicon supported) / Linux
Supported Target Build Platforms: Win64 / Mac / Linux / Android / iOS
video tutorial: https://www.youtube.com/watch?v=QIphNOFV0j0&list=PL9BLqOUwm7Rqgn7GQZoTkZPFvy9K7rarF&index=33&t=9s