There's not going to be much of a difference between SQL and CDS. You can accomplish your goal with either one. I would suggest you using whatever you are strongest with.
Moving to a different datasource will increase your costs though. To use SQL or CDS its monthly cost is either $10 per app/per user $40 unlimited per user.
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Check out the on demand sessions that are available now!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Features releasing from October 2020 through March 2021
Check out the Power Platform Community Highlights