Would the data be encrypted at all stages ( at rest, in motion and in use/transit )

YES.  The database is encrypted at REST and all data is encrypted in transit.