We present a neural approach called IRNet for complex and cross-domain Text-to-SQL. IR-Net aims to address two challenges: 1) the mismatch between intents expressed in natural language (NL) and the implementation details in SQL; 2) the challenge in predicting columns caused by the large number of outof-domain words. Instead of end-to-end synthesizing a SQL query, IRNet decomposes the synthesis process into three phases. In the first phase, IRNet performs a schema linking over a question and a database schema. Then, IRNet adopts a grammar-based neural model to synthesize a SemQL query which is an intermediate representation that we design to bridge NL and SQL. Finally, IRNet deterministically infers a SQL query from the synthesized SemQL query with domain knowledge. On the challenging Text-to-SQL benchmark Spider, IRNet achieves 46.7% accuracy, obtaining 19.5% absolute improvement over previous state-of-the-art approaches. At the time of writing, IRNet achieves the first position on the Spider leaderboard.

No abstract

Objective. To assess the short-term efficacy and safety of two kinds of Traditional Chinese herbal patches, Fufang Nanxing Zhitong Gao (FNZG) and Shangshi Jietong Gao (SJG), for painful knee osteoarthritis (OA). Methods. Patients were randomly enrolled in a double-blind, placebo-controlled study to receive FNZG (n = 60), SJG (n = 60), or placebo patch (n = 30) for 7 days. Outcome measures included visual analogue scale (VAS), Western Ontario and McMaster Universities Osteoarthritis Index (WOMAC), and Traditional Chinese Medicine Syndrome Questionnaire (TCMSQ) subscale. Results. Although there was no significant difference among, three groups in short-term pain management, patients receiving FNZG got significant improvement in symptom of fear of coldness as compared with placebo patch (P = 0.029). The most common local adverse events of rash, itching, erythema, and slightly damaged skin were observed in 7% of participants. Conclusions. FNZG may be a useful treatment for symptom of knee OA and merits long-term study in broader populations.

A StcA-AfoE hybrid PKS, generated from swapping the AfoE (asperfuranone biosynthesis) SAT domain with the StcA (sterigmatocystin biosynthesis) SAT domian, produced a major new metabolite with the same chain length as the native AfoE product. Structure elucidation allowed us to propose a likely pathway and feeding studies supported the hypothesis that the chain length of PKS metabolites may be under precise control of KS and PT domains.