如何在magento 2中使用直接sql查询来获取产品信息？

<?php
namespace Vendor\Module\Model;

use Magento\Framework\App\ResourceConnection;

class ProductInfo
{
    protected $connection;

    public function __construct(ResourceConnection $resource)
    {
        $this->connection = $resource->getConnection();
    }

    public function getProductInfo()
    {
        $tableName = $this->connection->getTableName('catalog_product_entity');
        $sql = "SELECT * FROM " . $tableName;

        $result = $this->connection->fetchAll($sql);

        // 处理结果集并使用所需的产品信息
        foreach ($result as $row) {
            // 处理每个产品信息
            // $row['entity_id']为产品ID，$row['name']为产品名称等等
        }
    }
}