Pure SQL extractors

[hazyresearch]

Pure SQL extractors

[zifeishan]

People can now do it. Example:

ext_sentence_author {
      style: "sql_extractor"
      dependencies: ["ext_sentences_nlp"]
      sql: """
        DROP TABLE IF EXISTS sentence_author CASCADE;

        CREATE TABLE sentence_author (
            id bigserial primary key,
            sentence_id bigint,
            publication_id bigint,
            author_id bigint,
            is_true boolean
          ) ;

        INSERT INTO sentence_author (sentence_id, publication_id, 
                author_id, is_true)
        SELECT  sentences.id AS sentence_id, 
                document_id AS publication_id, 
                authors.author_id,
                null::boolean is_true
          FROM  sentences, authors;
      """
    }

before / after script is still acceptable in these extractors.