How to query a database from my Flask python app?

@app.route('/')
def index():
    results = result.fetchall() # get all rows 
    return render_template('index.html', data=results)

{{ data }}

{% for row in data %}

    {% for item in row %}
      {{ item }}
    {% endfor %}

{% endfor %}