What is the best way to use SQL on-premise data within SharePoint Online?

[Kevin McKeown]

We would like to create a solution in SharePoint Online that can perform CRUD operations on data in an on-premise SQL database.

What is the best way to accomplish this?

What are the different options?

Is it possible to do this from a SharePoint Framework web part?

[#2]

Best way is to create a PowerApp that consume SQL On-Premises data, but this option implies to have a paid Plan of PowerApps since SQL connector is a premium one.

[#3]

Are there any other options besides PowerApps? Is it possible to create a SharePoint Framework web part that connects to SQL data?