title: How to use SQLAlchemy to create a full text search index on SQLite and query it?
body: <p>I am create a simple app which can performance basic operations. SQLite is used as database. I want to perform wildcard search but I know that it has poor performance. I want to try out full text search but I cannot full a example on 
   how to do it. I confirmed that SQLite has <a href="https://sqlite.org/fts5.html" rel="noreferrer">full text search support</a>. Here is my sample code.</p>
  
  <pre><code>from flask_sqlalchemy import SQLAlchemy
  
  db = SQLAlchemy()
  
  class Person(db.Model):
      id = db.Column(db.Integer, primary_key=True)
      name = db.Column(db.Text, unique=True, nullable=False)
      thumb = db.Column(db.Text, nullable=False, default="")
  
      role = db.relationship("Role", backref="person", cascade="delete")
  
  
  class Role(db.Model):
      id = db.Column(db.Integer, primary_key=True)
      person_id = db.Column(db.Integer, db.ForeignKey(Person.id, ondelete="CASCADE"), nullable=False)
      role = db.Column(db.Text, nullable=False)
  </code></pre>
  
  <p>How can I create a FTS index and query it using SQLAlchemy. For example, searching name in Person.</p>