如何从列包含图像数组数据库中检索图像完整url？

CREATE TABLE products (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    images JSON
);

INSERT INTO products (name, images) VALUES ('Product A', '["image1.jpg", "image2.jpg"]');

SELECT id, name, JSON_UNQUOTE(JSON_EXTRACT(images, '$[*]')) AS image_urls
FROM products;

from sqlalchemy import create_engine, Column, Integer, String, JSON
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

Base = declarative_base()

class Product(Base):
    __tablename__ = 'products'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    images = Column(JSON)

engine = create_engine('mysql+pymysql://user:password@host/dbname')
Session = sessionmaker(bind=engine)
session = Session()

# 查询所有产品的图像URL
products = session.query(Product).all()
for product in products:
    print(f"Product ID: {product.id}, Name: {product.name}, Image URLs: {product.images}")