public async Task <string> ExecuteSQLAsync(string query)
        {
            NpgsqlConnection conn = (NpgsqlConnection)AssignmentService.GetDbConnection();
            await conn.OpenAsync();

            NpgsqlCommand cmd = new NpgsqlCommand(query, conn);

            DbDataReader reader = await cmd.ExecuteReaderAsync();

            string output = "";

            do
            {
                output += await GetSQLResultAsync(reader);
            }while (await reader.NextResultAsync());

            reader.Close();

            return(output);
        }