Hi Mikhail and Alexander,
I wonder if there are any plans to introduce a Bingo query node (or Bingo DB connector, Bingo DB structure query node, Bingo DB reaction query node, Bingo DB connection reader node family)?
At the moment, I find that I have to maintain and modify a lot of SQL by hand, for offering different query options, etc. It would be great if a node took all the hard-work out of this by giving a user-friendly interface for the following sorts of things:
- Choosing the database, table, and structure/reaction column to query
- Choosing the query type (exact, substructure, similarity, superstructure)
- Query options - tautomer, etc
- Return options - ability to select other values from the same database table, and also offer check-boxes for addition of Bingo function results to be added as returned columns (InChi, cansmiles, etc)
Of course, one would want this to also all work seemlessly regardless of connecting to Oracle, postgres, or SQL Server(!)
Kind regards
James