ALTER DATABASE "DATABASE-OLD" --OLD
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
EXEC rdsadmin.dbo.rds_modify_db_name N'DATABASE-OLD', N'DATABASE' --this is similar to on-prem "ALTER DATABASE dbName MODIFY NAME = dbNewName"
ALTER DATABASE "DATABASE" --NEW
SET MULTI_USER WITH ROLLBACK IMMEDIATE