Using custom function and returning json val from Postgres

[NaN]

Can we select without a table in ecto?

This can be done but its hacky. However, IMO it should not be removed (PLEASE DONT REMOVE THIS we want the query scrubbed without the FROM condition) taking from SQL injection you can use -- to rem out the FROM condition. MyRepo.all( from(d in "_", select: %{ test: fragment("to_timestamp('11:12:02.020.001230', 'HH:MI:SS.MS.US') as slot--") } ) )

This can be done but its hacky. However, IMO it should not be removed (PLEASE DONT REMOVE THIS we want the query scrubbed without the FROM condition) taking from SQL injection you can use -- to rem out the FROM condition.

MyRepo.all(
      from(d in "_",
        select: %{
          test: fragment("test(?,?,string_to_array(?, ',')::int[])--", ^from, ^to, ^list)
        }
      )
    )