FlyBase has started placing our report field mapping tables on the GMOD wiki. These tables explicitly define the SQL required to fetch data for all fields in our reports. Thus far, we have mapping tables completed for Genes, Polypeptides, and References with more to come shortly.
Please let us know what you think and if you find this sort of thing helpful.
Josh
