How can remote interface query data or multi table custom query data be displayed in grid?

I’d like to call a remote interface or customize SQL query data and display it as a list on the page and support paging, but the current Grid doesn’t seem to support it. What should I do?

You can create custom view(Check developer guide). But its only supported for dashboard for the moment.