title: Convert hypertable to regular postgres table
body: <p>quite new to timescaledb and I'm struggling with a migration script. I'm trying to create migrations for a flask application with SQLAlchemy.</p>
  
  <p>Let's say I created a table (as in timescaledb docs) like the following:</p>
  
  <pre><code>CREATE TABLE conditions (
    time        TIMESTAMPTZ       NOT NULL,
    location    TEXT              NOT NULL,
    temperature DOUBLE PRECISION  NULL,
    humidity    DOUBLE PRECISION  NULL
  );
  </code></pre>
  
  <p>To add the hypertable, my upgrade migration script should do:</p>
  
  <pre><code>SELECT create_hypertable('conditions', 'time');
  </code></pre>
  
  <p>What should the downgrade part look like ?
  From <a href="https://docs.timescale.com/latest/using-timescaledb/hypertables#drop" rel="noreferrer">timescaledb docs</a>, they suggest:</p>
  
  <pre><code>DROP table conditions;
  </code></pre>
  
  <p>But I don't want the whole table to be dropped, only the "hypertable" part if that makes sense. Maybe this is silly and pointless, I want to provide a way out of timescaledb via our migrations. I've already read this SO question: <a href="https://stackoverflow.com/questions/50862609/creating-hypertables-through-sql-alchemy">Creating Hypertables through SQL Alchemy</a> where no specific support seems provided for SQLAlchemy and they suggest triggers to create hypertables instead of a specific migration.</p>
  
  <p>What would you suggest ?</p>