display mysql data on a wordpress page

Hi All, I’m helping to develop a WordPress site and we want to integrate it with a backend custom mysql database that we’ve created. I want to use some php code to grab some data from the mysql database and post it on some of our WordPress pages as a report. What is the usual and best way to do this? I see plugins that allow me to put php code onto a WordPress page. Is that the usual way? Or is there some other best practice to do this? I’m new to WordPress and php coding. Is it better to use something like wpdatatables or Tabulizer rather than inserting php code on a page? Thanks,