Yes you could create an override in the article view template file, and make a call to the db to fetch articles and display them.
But maybe it would be better to use an article module for this.
If your template has a module position below the component (content) location, you could assign it there. If it doesn't then you could create a new one.
If showing the module in a module position is not what you want, it's also possible to make the module load inside the article.
You can always load modules inside an article, with the {loadposition positionx} - with the Content Plugin - Load Modules being enabled.
If you want all articles to include the module, and being tired with the process of manually adding the module to each article, then you could create an override for the article view and have the module loaded dynamically.
Create a template override for the article and use anywhere you like, guess you want it after the article content, so that would be somewhere after:
$this->item->text;
Code to load module inside the article template:
<?php
jimport( 'joomla.application.module.helper' );
$modules = JModuleHelper::getModules( 'articlebottom' ); // Get Modules assigned at a position articlebottom (Returns and array)- it can be a custom position.
$attribs = array('style' => 'xhtml'); // define module attributes, like module chrome.
if (count($modules)>0) { // Checking if there are modules ?>
<!-- Module wrapper -->
<div id="top-contentb" class="top-content">
<?php echo JModuleHelper::renderModule($modules[0], $attribs); // Render the first module of the $modules array.?>
</div>
*You can find more info about creating template overrides in here and in Joomla.org.
Finally, it worths checking in Joomla Extensions Directory for articles extensions - apart of the modules, there could be content plugin that can load articles suggestions (like similar articles, recent articles, category articles etc).
