shasta | De novo assembly from Oxford Nanopore reads | Genomics library

Try

instance = await tronWeb.contract().at(trc20ContractAddress)

Something like this:

What about something like:

I'm trying to understand your question.
Are you want to use default parameters?

Well, Solidity does not support default parameters, but it is on their roadmap (see https://github.com/ethereum/solidity/issues/232). To work around this, just use function overloading:

You can use str_extract_all to extract all the states and unnest to duplicate rows such that each state is in a separate row. There is an inbuilt constant state.name which have the state names of US which can be used here to create pattern.

Try this query:

In ABI, any return value of a struct type will be interpreted as tuple. In your case, its type is tuple[].

The library has no clue what's your tuple is, how long it is, what's the type.

You should parse the return data by hand.

This seems like a regression bug in tronbox 2.7.4 and 2.7.5 since when I use tronbox 2.5.2 everything works smoothly.

Don't want to override the SQLRaptor's helpful response in comments, but for the sake of completeness :)

SQL treats integer division as integer, therefore truncating it. To avoid that -- cast at least one of the values to a floating point data type (e.g. REAL or FLOAT for SQLite -- check the manual on data types here: https://www.sqlite.org/datatype3.html)