Which database or ORM framework uses these function calls?

You can probably do what you are hoping to with the existing framework - no reason Query or QueryRow can't return you tens or hundreds of megabytes of data.

I think every Database has this kind of function calls. As I work on Db2(IBM database), it has SQLPutData() and SQLGetData().

The above API's take Statement handle as one of the parameters and variables in statement object (st,err := db.Prepare(query) ) are unexported and I can't use it even if I extend the sql.Stmt.

/cc @kardianos

Can you point me to the docs on what you are trying to do? Are you trying to upload large amounts or rows like a bulk row upload? Maybe an example that demonstrates how you would use this?

package main

import (
    "database/sql"
    "fmt"
    _"github.com/ibmdb/go_ibm_db"
)

func main() {
    con := "HOSTNAME=localhost;PORT=50000;DATABASE=dbname;UID=uname;PWD=password;"
    db, err := sql.Open("go_ibm_db", con)
    if err != nil {
        fmt.Println(err)
    }
	defer db.Close()
    st,err:=db.Prepare("Insert into putdata(a,b) values(?,?)")
	if err != nil{
	fmt.Println(err)
	}
	defer st.Close()
	
	// If user wants to send the data at execute time.
	// He will send the some empty string or empty byte array or something to notify the execute api
	// that data will be send later.
	st.Query("","")
	// From Here Its My vision of functions how to send the data.
	st.ParamData()
	//Here I am reading the normal data. He may read chunks of Data from file 
	st.PutData("Akhil")
	st.PutData(" Ravuri")
	//This paramData function will set the next parameter to be inserted.
	//If there are no Parameter's the it will execute the query.
	st.ParamData()
	st.PutData("Sai")
	st.PutData(" Ram")
	st.ParamData()
}

In the example I have taken the string, suppose if the user wants to store lob data in the database which is of 2GB (As of I know a buffer can't handle 2GB of Data at once) , then he wants to send them in chunks of data then he will call multiple Putdata's and then store the data.
In the same way, while getting the Data from the Database GetData is used.

When Binding the columns if we use this SQL_DATA_AT_EXEC (In Db2) in column value , then execute api will be waiting for the data and and when we send the data to the column, then it will execute the query.

Ah, yes, that makes much more sense. Thanks for the context. This is a usecase I'd like to enable with database/sql/v2, but the current API doesn't really allow for this at the moment. You'll need to use the direct DB2 API I think. I'll look into that driver.

Thanks for the quick turn around, As many users are store lob data in the database it will be useful and when Go is planning to release database/sql/v2.

If I understand your usecase correctly, after thinking about it for awhile, you can probably implement this in your driver with the current interface.

The key is to implement the https://godoc.org/database/sql/driver#NamedValueChecker Named Value Checker, then allow the user to pass in some type of reader, possibly an io.Reader or other chunk based reader. Then the driver can upload parameters as it reads it off in chunks.

NamedValueChecked is just declared in the driver file and no sign of it in the sql file. How to call that function. Is there any example on how to use it.

Fair point. I don't remember if we have examples for that driver member. Here is an example for a SQL Server driver, which supports a number of non-stdlib types:

https://github.com/denisenkom/go-mssqldb/blob/master/mssql_go19.go#L66

Thanks for the information. But that did not help me. Correct me If I am wrong, As of what I know If a user writes an application using the driver the flow is

Application(Database program) --->database/sql/sql.go -----> database/sql/driver/driver.go(where the function are declared) -----> imported Driver.

So if the user wants to use it(NamedValueChecked) at the application side it should be present in the database/sql/sql.go or else it will produce an error that function is not defined in the sql.go

So, what is the equivalent function in the in sql.go for NamedValueChecked?
I will go through the docs to check whether it is helpful for my case or not.

If I extend the interface and add a function to the Stmt handle it will not work because the PutData and get Data functions Require SQLHSTMT as one of the parameters and which is stored in the driver.Stmt. Since driver.Stmt is not exported in the Stmt I cannot access SQLHSTMT.

If there are Read, write specifiers like export and unexport then it will be too easy.

@akhilravuri1 The Db.Conn.Raw method may help you interact with a driver's native capability. However, I do not expect to add this type of functionality into the current database/sql interface.

I suggest we decline/close this request.

I'm going to close this request. For this specific of capabilities, please sue the Conn.Raw method.